Month – May 2007

How Long?

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!  

Firewalls and SMS

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 […]

Find PCs without .Net 2.0 or .Net 3.0

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 […]

Announcing: MatchIT

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 […]

Find PCs without .Net 3.0

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

Find PC with .Net 3.0

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

Find PCs with .Net 2.0

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

Find all PCs without .Net 2.0

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