|
st0kes -> Report of all Microsoft products installed on the network (9/30/2008 12:27:11 PM)
|
I've been asked to create a report of all Microsoft products installed on all machines on the network. I thought I would rehash the existing "Computers with a specific product" report for this, but in doing so I have created a report that has 80,000 results and crashes the browser. How do I configure the report to display each computer as an expandable element?
This is how it looks so far.
Select SYS.Netbios_Name0, SYS.User_Name0, SP.ProductName, SP.CompanyName, SP.ProductVersion
FROM v_GS_SoftwareProduct SP
JOIN v_R_System SYS on SP.ResourceID = SYS.ResourceID
WHERE SP.ProductName like '%Microsoft%'
Order by SP.ProductName, SP.ProductVersion
|
|
|
|
