It took 2 hours, 4 minutes and 8 second to return 524031 rows from a db with ~3500PCs and isqlw.exe consumed just under 560MB of RAM. Don’t try to run the “All programs for each PC within a collection” as a web report, it will not work!
Month: May 2007
During a resent discussion within the mailing list this request was posted. “I need to run a report of all software installed for each computer in a specific collection (or an AD site..Whichever)… Similar to the “Summary of Installed Software in a Specific Collection” report that comes with SP2, but rather than a summary, […]
Recently there have been a number of questions about how to have SMS working with firewalls. These KBs and documents will help you set up your firewall correctly. Scenarios and Procedures for Microsoft Systems Management Server 2003: Securityhttp://www.microsoft.com/downloads/details.aspx?FamilyID=3d81b520-a203-4376-a72d-fd34a6c4a44c&DisplayLang=en Service overview and network port requirements for the Windows Server systemhttp://support.microsoft.com/kb/832017 Ports that Systems Management […]
select distinct SMS_G_System_SYSTEM.Name from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.ResourceId not in (select distinct SMS_G_System_COMPUTER_SYSTEM.ResourceID from SMS_G_System_COMPUTER_SYSTEM inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_G_System_COMPUTER_SYSTEM.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like “%.NET Framework 2.0%”) and SMS_R_System.ResourceId not in (select distinct SMS_G_System_COMPUTER_SYSTEM.ResourceID from SMS_G_System_COMPUTER_SYSTEM inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_G_System_COMPUTER_SYSTEM.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like “%.NET Framework […]
From an email to me: What is MatchIT? MatchIT is an online environment where charities and not-for-profit organizations can connect with Developers, IT Pro’s, Designers, Students or other technical individuals willing to volunteer their time and expertise to bring technology solutions to these organizations. Our goal is to enable them to be more effective with […]
select distinct SMS_G_System_SYSTEM.Name from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.ResourceId not in (select distinct SMS_G_System_COMPUTER_SYSTEM.ResourceID from SMS_G_System_COMPUTER_SYSTEM inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_G_System_COMPUTER_SYSTEM.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like “%.NET Framework 3.0%”)order by SMS_G_System_SYSTEM.Name
select distinct SMS_G_System_COMPUTER_SYSTEM.Name from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like “%.NET Framework 3.0%” order by SMS_G_System_COMPUTER_SYSTEM.Name
select distinct SMS_G_System_COMPUTER_SYSTEM.Name from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like “%.NET Framework 2.0%” order by SMS_G_System_COMPUTER_SYSTEM.Name
select distinct SMS_G_System_SYSTEM.Name from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.ResourceId not in (select distinct SMS_G_System_COMPUTER_SYSTEM.ResourceID from SMS_G_System_COMPUTER_SYSTEM inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_G_System_COMPUTER_SYSTEM.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like “%.NET Framework 2.0%”) order by SMS_G_System_SYSTEM.Name
This will give you a count of collected files. SELECT vCollectedFile.FileName, Count(vCollectedFile.FileName) AS ‘Count’FROM vCollectedFile vCollectedFileGROUP BY vCollectedFile.FileNameORDER BY vCollectedFile.FileName