Client Management Suite

Hi,

I am trying to create a sql report that will show me the computer type but the computer type is showing blank.

Here is the sql script:

Select DISTINCT

c.[Name],

Vct.[Name] AS 'Computer Type'

FROM

vCMDBComputer c

left JOIN ResourceAssociation raloc on raLoc.ParentResourceGuid = c.Guid

and raLoc.ResourceAssociationTypeGuid LIKE '74C9AD4A-E384-477E-BD06-132A3368E58D'

left JOIN vComputerType vct on vct._ResourceGuid = raLoc.ChildResourceGuid

where c.[Name] like '%'

I need a report of all my computers that show me if they are a desktop or laptop.

Bump, anyone?

How about this?

select
	[vc1].[Name]
	, [vacct1].[Chassis Type]
from
	[vComputer] [vc1]
	left join [vAC_ChassisType] [vacct1] on [vc1].[Guid] = [vacct1].[Guid]
where [vc1].[IsManaged] = 1

Hi MyITGuy,

I tried running your sql script but I am not getting

This DataSource is not in a runnable state.

An error occured on the page.  Please check the log for more details.

MyITGuy’s  query should give you desired data.

You might just want to add _ItemGuid column so you can perform right click action:

select

       vc1.guid [_ItemGuid]

       ,[vc1].[Name]

       , [vacct1].[Chassis Type]

from

       [vComputer] [vc1]

       left join [vAC_ChassisType] [vacct1] on [vc1].[Guid] = [vacct1].[Guid]

where [vc1].[IsManaged] = 1

Bump Anyone?

That SQL Code works for me so you need to check your report paramters. Try:

SELECT Guid AS _ItemGuid
FROM  dbo.vComputer AS vc1

Then build up from there. look in the log file for more details of the error.

Why don't you use a default "All Computers" report of "CMDB Solution" product, where it shows whether this Virtual Machine or Physical Computer?

• In this report you will have a "Resource Type" field as report parameter to see "Any" or only "Virtual Machine" or "Physical Computer".

Open "Symantec Management Console" ⇒ "Reports" ⇒ expand "Service and Asset Management" folder ⇒ expand "Picker Reports" folder ⇒ click on "All Computers" report.

Thanks but I need to know if it's a laptop or desktop.

The above report worked just fine. :)

Try this to find laptops. It finds anything with a battery:

SELECT vc.[Guid]
FROM vComputer vc
JOIN vHWBattery hwb ON hwb._ResourceGuid=vc.Guid
WHERE vc.IsManaged=1

This has worked for us. You can also use it as an exclusion to all your endpoints and you should have desktops (and servers, if you manage them) left over. We've used it since 7.5 SP1 and still use it on 7.6 HF7.