Software Deployment

There are some good (if brief) script samples on MSDN. Start here http://msdn.microsoft.com/en-us/library/cc144365.aspx

The SCCM SDK is worth a d/l, too.

You could use a h/w inventory scan of A/R programs to determine if an app is installed or not.

This query is stolen from here:
http://www.myitforum.com/forums/m_171013/mpage_1/key_framework/tm.htm#171353

It will install an app for a machine whose computer account is in the AD group "adgrpMicrosoftNETFramework11" and not in the AD group "Domain\\adgrpSpecialUseComptures" and that does not have the Add/remove programs entry "Microsoft .NET Framework 1.1".


SELECT SMS_R_System.*
FROM SMS_R_System WHERE
(SMS_R_System.ResourceID In
(SELECT ResourceID FROM SMS_R_System WHERE SystemGroupName = "Domain\\adgrpMicrosoftNETFramework11"))
AND
(SMS_R_System.ResourceID Not In
(SELECT ResourceID FROM SMS_R_System WHERE SystemGroupName = "Domain\\adgrpSpecialUseComptures"))
AND
(SMS_R_System.ResourceID Not In
(SELECT ResourceID FROM SMS_G_System_ADD_REMOVE_PROGRAMS
WHERE SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Microsoft .NET Framework 1.1"))


Lee, a thought occured to me. When you say 'advertised', do you mean advertised by SCCM or by Windows Installer? I have no clue how you might detect SCCM advertisement but WI is easy enough, by querying the WindowsInstaller.Installer ProductState property. It's also available from WMI, meaning that you can query remotely http://msdn.microsoft.com/en-us/library/aa394378(VS.85).aspx