st0kes
Posts: 3
Score: 0
Joined: 2/14/2008
Status: offline
|
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
|
Printable Version
Report of all Microsoft products installed on the network - 
New Messages
No New Messages
Hot Topic w/ New Messages
Hot Topic w/o New Messages
Locked w/ New Messages
Locked w/o New Messages
Post New Thread