Hi Joe
Thanks for the reply. I used an almost identical version of your report
Select Case SE.ChassisTypes0
When 1 Then 'Other'
When 2 Then 'Unknown'
When 3 Then 'Desktop'
When 4 Then 'Low Profile Desktop'
When 5 Then 'PizzaBox'
When 6 Then 'Mini-Tower'
When 7 Then 'Tower'
When 8 Then 'Portable'
When 9 Then 'Laptop'
When 10 Then 'Notebook'
When 11 Then 'Handheld Device'
When 12 Then 'Docking Station'
When 13 Then 'All-In-One'
When 14 Then 'Sub-Notebook'
When 15 Then 'Space Saving'
When 16 Then 'Lunch Box'
When 17 Then 'Main System Chassis'
When 18 Then 'Expansion Chassis'
When 19 Then 'Sub-Chassis'
When 20 Then 'Bus Expansion Chassis'
When 21 Then 'Peripheral Chassis'
When 22 Then 'Storage Chassis'
When 23 Then 'Rack-Mount Chassis'
When 24 Then 'Sealed PC'
Else 'Unknown'
End 'Chassis Type',
Count(*) 'Chassis Count'
From v_GS_System_Enclosure SE
Join v_R_System SD on SE.ResourceID = SD.ResourceID
Join V_GS_Operating_System OS on SE.ResourceID = OS.ResourceID
Join v_FullCollectionMembership CM on SE.ResourceID = CM.ResourceID
Where SE.Manufacturer0 LIKE @Manufacturer0
AND OS.Version0 LIKE @Version0
AND CM.CollectionID LIKE @CollectionID
Group By SE.ChassisTypes0
So, what we should see is one record in SE for each ResourceID, one record in OS for each ResourceID. Now if I enter in SMS% for CollectionID what I see is (because the system is in 3 collections) the count going up to 3 instead of remaining at 1 for
example.
What I want to achieve is that we can slice and dice the data by Manufacter, OS Version, CollectionID or be able to offer a null parameter and show everything
