Client Management Suite

 View Only

  • 1.  Specific Computer

    Posted Oct 29, 2013 07:21 AM

    Hi,

    What I am trying to do is get a report a specific computer model at each defined location.

    anyone help me if you guys can.



  • 2.  RE: Specific Computer
    Best Answer

    Posted Oct 29, 2013 07:24 AM

    Try this,

    as long as you have your sites and subnets assigned, this will show you the computers that are 8300's assigned to the site.

    SELECT DISTINCT  
    i.Name AS 'Site'
    ,ip.[Subnet]
    ,vc.[Name]
    ,vc.[OS Revision]
    ,vhw.Model
    ,vhc.[Chassis Package Type] AS 'Serial Number'
    ,vhw.[Identifying Number]
    ,vhw.Manufacturer
    ,vc.[User] AS 'Primary Owner'
      
    FROM 
    vsite i  
    LEFT JOIN vSiteResource sr on i.Guid=sr.Guid  
    LEFT JOIN vSiteSubnetMap ss on sr.Guid=ss._ResourceGuid  
    LEFT JOIN vSubnet sn on ss.SubnetGuid=sn.Guid  
    LEFT JOIN Inv_AeX_AC_Tcpip tcp on tcp.Subnet=sn.Subnet and tcp.[Subnet Mask]=sn.[Subnet Mask]  
    LEFT JOIN vComputer vc on vc.Guid = tcp._resourceGuid 
    LEFT JOIN Inv_Aex_AC_TCPIP ip ON ip.[_ResourceGuid] = vc.GUID 
    LEFT JOIN vHWComputerSystem vhw ON vc.GUID = vhw.[_ResourceGuid]
    LEFT JOIN vHWProcessor vhp ON vc.GUID = vhp.[_ResourceGuid] 
    LEFT JOIN vHWChassis vhc ON vc.Guid = vhc._ResourceGuid
    LEFT JOIN [CollectionMembership] cm ON cm.[ResourceGuid] = vc.GUID
    WHERE vc.IsManaged = '1' AND vhw.Model LIKE '%8300%'
     
    Check thread,