Client Management Suite

 View Only
  • 1.  Dynamic Laptop Filter in ITMS 7.1

    Posted Apr 08, 2011 05:20 PM
      |   view attached

    Hi

    It appears there is no "Laptop Filter" and I think we all need this badly. I am trying to find exact table to identify a laptop. I discovered Chassis property under >Computer Resource>Hardware>Chassis is not returning any value. Can anyone check in your enviornment ? Any other ideas to create a "Dynamic Laptop" filter.

    Thanks,

     

     

    Attachment(s)

    docx
    ChassisProperty.docx   141 KB 1 version


  • 2.  RE: Dynamic Laptop Filter in ITMS 7.1

    Posted Apr 09, 2011 01:01 PM

    Create a new computer report, add a filter expression for Chassis Package Type, convert to a SQL query, then add this CASE statement right above the WHERE clause, at the end of your SELECT statement:

     Case When Inv_HW_Chassis.[Chassis Package Type] = 1 Then 'Other'
      When Inv_HW_Chassis.[Chassis Package Type] = 2 Then 'Unknown'
      When Inv_HW_Chassis.[Chassis Package Type] = 3 Then 'Desktop'
      When Inv_HW_Chassis.[Chassis Package Type] = 4 Then 'Low Profile'
      When Inv_HW_Chassis.[Chassis Package Type] = 5 Then 'Pizza Box'
      When Inv_HW_Chassis.[Chassis Package Type] = 6 Then 'Mini Tower'
      When Inv_HW_Chassis.[Chassis Package Type] = 7 Then 'Tower'
      When Inv_HW_Chassis.[Chassis Package Type] = 8 Then 'Portable'
      When Inv_HW_Chassis.[Chassis Package Type] = 9 Then 'Laptop'
      When Inv_HW_Chassis.[Chassis Package Type] = 10 Then 'Notebook'
      When Inv_HW_Chassis.[Chassis Package Type] = 11 Then 'Hand Held'
      When Inv_HW_Chassis.[Chassis Package Type] = 12 Then 'Docking Station'
      When Inv_HW_Chassis.[Chassis Package Type] = 13 Then 'All in One'
      When Inv_HW_Chassis.[Chassis Package Type] = 14 Then 'Sub Notebook'
      When Inv_HW_Chassis.[Chassis Package Type] = 15 Then 'Space-Saving'
      When Inv_HW_Chassis.[Chassis Package Type] = 16 Then 'Lunch Box'
      When Inv_HW_Chassis.[Chassis Package Type] = 17 Then 'Main System'
      When Inv_HW_Chassis.[Chassis Package Type] = 18 Then 'Expansion Chassis'
      When Inv_HW_Chassis.[Chassis Package Type] = 19 Then 'Sub Chassis'
      When Inv_HW_Chassis.[Chassis Package Type] = 20 Then 'Bus Expansion'
      When Inv_HW_Chassis.[Chassis Package Type] = 21 Then 'Peripheral Chassis'
      When Inv_HW_Chassis.[Chassis Package Type] = 22 Then 'Storage Chassis'
      When Inv_HW_Chassis.[Chassis Package Type] = 23 Then 'Rack Mount'
      When Inv_HW_Chassis.[Chassis Package Type] = 24 Then 'Sealed-Case PC' End as [Chassis Type]
     

    Your filter expression will be based on [Chassis Package Type] numerical values, so look at this list and decide what constitutes a laptop for your environment.  In most environments, it's values 8, 9, 10, 12.  Add it four times, one for each.  (If [Chassis Package Type] "EQUALS" 8, and so on.)  If [Chassis Package Type] is empty, confirm that your computers have run a software and hardware inventory.  I'm pretty sure it's software (because this is in the BIOS, which is software), but run both just to be sure.

    Does this help?



  • 3.  RE: Dynamic Laptop Filter in ITMS 7.1

    Posted Apr 11, 2011 11:35 AM

    Thank you very much for the details. Does Chassis property retruns any value in your enviornment ?



  • 4.  RE: Dynamic Laptop Filter in ITMS 7.1

    Posted Apr 11, 2011 12:59 PM

    Yes, it returns value.  This requires running a software and a hardware inventory.  Again, like I said, probably software but do a hardware if it doesn't show up.



  • 5.  RE: Dynamic Laptop Filter in ITMS 7.1

    Posted Apr 11, 2011 02:08 PM

    I got it working using SQL query. May be I was not clear on my question when I go to >Resource Manager>Data Classes>Hardware>Chassis I do see the Value but it is not showing Property Name. I think I attached a screen shot. Thanks for your help.



  • 6.  RE: Dynamic Laptop Filter in ITMS 7.1

    Posted Sep 06, 2011 11:18 PM

    SELECT DISTINCT

    vRM_Computer_Item.Name, Inv_HW_Logical_Device.Manufacturer, Inv_HW_Logical_Device.Model, Inv_AeX_AC_Identification.[OS Name],

    Inv_AeX_AC_Primary_User.[User], ISNULL(CAST(CAST(Inv_HW_Storage.[Max Media Size (Kilobytes)] / (1024 * 1024) AS DECIMAL(10, 0)) AS NVARCHAR(MAX)), '--')

    AS [HDD Size (GB)], Inv_SW_BIOS_Element.[Release Date] AS [BIOS Release Date],

    ISNULL(CAST(CAST(vHWComputerSystem.[Total Physical Memory (Bytes)] / (1024.0 * 1024.0) AS DECIMAL(10, 0)) AS NVARCHAR(MAX)), '--') AS [RAM (MB)],

    derivedtbl_1.[Memory Devices]AS [Total Number of Slots], temp.[Used Slots]

    FROM vRM_Computer_Item INNER JOIN

    Inv_HW_Logical_Device ON vRM_Computer_Item.Guid = Inv_HW_Logical_Device._ResourceGuid INNER JOIN

    Inv_AeX_AC_Identification ON vRM_Computer_Item.Guid = Inv_AeX_AC_Identification._ResourceGuid INNER JOIN

    Inv_AeX_AC_Primary_User ON vRM_Computer_Item.Guid = Inv_AeX_AC_Primary_User._ResourceGuid INNER JOIN

    Inv_HW_Storage ON vRM_Computer_Item.Guid = Inv_HW_Storage._ResourceGuid INNER JOIN

    Inv_SW_BIOS_Element ON vRM_Computer_Item.Guid = Inv_SW_BIOS_Element._ResourceGuid INNER JOIN

    vHWComputerSystem ON vRM_Computer_Item.Guid = vHWComputerSystem._ResourceGuid LEFT OUTER JOIN

    (SELECT SUM([Memory Devices]) AS [Memory Devices], _ResourceGuid

    FROM vHWPhysicalMemoryArray

    WHERE ([Use] = 3)

    GROUP BY _ResourceGuid) AS derivedtbl_1 ON derivedtbl_1._ResourceGuid = vHWComputerSystem._ResourceGuid LEFT OUTER JOIN

    (SELECT COUNT(DISTINCT Inv_HW_Physical_Memory_Location.[Part Component]) AS [Used Slots], vHWPhysicalMemory._ResourceGuid

    FROM vHWPhysicalMemory INNER JOIN

    Inv_HW_Physical_Memory_Location ON vHWPhysicalMemory._ResourceGuid = Inv_HW_Physical_Memory_Location._ResourceGuid AND

    vHWPhysicalMemory.[Device ID] = Inv_HW_Physical_Memory_Location.[Part Component] INNER JOIN

    vHWPhysicalMemoryArray AS vHWPhysicalMemoryArray_1 ON

    vHWPhysicalMemoryArray_1._ResourceGuid = Inv_HW_Physical_Memory_Location._ResourceGuid AND

    vHWPhysicalMemoryArray_1.Tag = Inv_HW_Physical_Memory_Location.[Group Component]

    WHERE (vHWPhysicalMemoryArray_1.[Use] = 3)

    GROUP BY vHWPhysicalMemory._ResourceGuid) AS temp ON temp._ResourceGuid = vHWComputerSystem._ResourceGuid

    WHERE (vRM_Computer_Item.Guid IN

    (SELECT DISTINCT vRM_Computer_Item_1.Guid

    FROM vRM_Computer_Item AS vRM_Computer_Item_1 INNER JOIN

    Inv_HW_Logical_Device AS Inv_HW_Logical_Device_1 ON vRM_Computer_Item_1.Guid = Inv_HW_Logical_Device_1._ResourceGuid

    WHERE (Inv_HW_Logical_Device_1.Description LIKE '%battery%'))) AND (Inv_HW_Logical_Device.Description LIKE 'AT/AT COMPATIBLE') AND

    (Inv_HW_Storage.[Media Type] LIKE '29') AND (Inv_HW_Storage.[Interface Type] NOT LIKE 'USB%') AND (Inv_HW_Storage.[Max Media Size (Kilobytes)] > 200000)