ITMS Administrator Group

Is there report that shows if a computer is physical or virtual computer?

Filter shows the computer type but i can't find the table or report that shows if a computer is a virtual or physical

Yes go off vasset - we also have naming standards to help us 

COALESCE(  Case when (LEFT (ac.name,1)='l') then 'Laptop' else Null end,
        case when LEFT (ac.name,1)='C' then 'Desktop' else Null end,
        case when LEFT (ac.name,1)='T' then 'Thin Client' else Null end,
        case when ac.[OS Name] like '%server%' then 'Server' else Null end,
        case when vasset.[Asset Type]= 'Virtual Machine'then 'Virtual' else Null end ) 
    as 'Machine Type',

All virtual machines clients are stored in this SQL table Inv_AeX_AC_VirtualMachine

Therefore you can exclude all exiting computers with flag "IsManaged"=1 from Inv_AeX_AC_VirtualMachine SQL table for vComputer SQL table to get report which will shows only physical servers from vComputer table.

Hi Billy,

   You can find the Virtual machines using the query

SELECT     dbo.Inv_AeX_AC_VirtualMachine.Product, dbo.Inv_AeX_AC_VirtualMachine.Version, dbo.vComputer.Name
FROM         dbo.Inv_AeX_AC_VirtualMachine LEFT OUTER JOIN
                      dbo.vComputer ON dbo.Inv_AeX_AC_VirtualMachine._ResourceGuid = dbo.vComputer.Guid

vcomputer will contains all the active machines which are Virtual and Physical servers.

Billy,

here's a query that will show a summary and details of virtual and regular computers.. You could take this query create a report will drill down...

--- summary query....

select

     va.[Asset Type], COUNT(*) as [Count]

from vAsset va

where va.[Asset Type] in ('Computer','Virtual Machine')

group by va.[Asset Type]

---- detail query ----

SELECT

      VA.[Asset Type], VI.Name AS [COMPUTER NAME]

FROM vAsset VA

JOIN vItem VI ON VI.Guid = VA._ResourceGuid

where va.[Asset Type] in ('Computer','Virtual Machine')

ORDER BY VA.[Asset Type], VI.Name

that works for VMware not Xen Desktop 

could you help me adding a field in a report (built in Computer Summary) where it would show the whether it is a virtual or physical computer? That way I can incorporate this field to any reports

Hi anton, I am looking for a simple field just like when you open a Filter, there is a ''Resource Type' that either says Computer or Virtual Machine.  Is there a way to implement that to a report?

If you mean the unique query which can be just copy/paste to any report/filter - No. Report and filters could have the various structure inside and that simple field will be different depending to each case.