Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SMS 2.0 QUERY TO FIND IF ALL USERS HAVE NEWEST WINDOWS 2000 PATCH
- Thread starter BILJANAS
- Start date
Well short of editing your mof or using monster mof from Michael Shultz its a tuff thing to do.
You can download msba 1.2 and it will allow you to scan subnets for all the latest on your machines but that checks for what your don't have.
Another way is to make a package with SMS that checks for the registry key thats inserted by the patch and writing that to a log file. If you want to do that I could cut and paste an example of it.
And last but not least install SUS FP, but this still won't show who needs it, it just will give to those that need it, if pushed/advertised.
Tim B
You can download msba 1.2 and it will allow you to scan subnets for all the latest on your machines but that checks for what your don't have.
Another way is to make a package with SMS that checks for the registry key thats inserted by the patch and writing that to a log file. If you want to do that I could cut and paste an example of it.
And last but not least install SUS FP, but this still won't show who needs it, it just will give to those that need it, if pushed/advertised.
Tim B
I just created this query which you can modify. Knock this around and see if it's what your seeking.
It wil prompt you for the filename. size and creation date.
If that's too much criteria, you can change it.
Good Luck!
select SMS_G_System_CollectedFile.FileName from SMS_R_System inner join SMS_G_System_CollectedFile on SMS_G_System_CollectedFile.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = ##PRM:SMS_G_System_SoftwareFile.FileName## and SMS_G_System_SoftwareFile.CreationDate = ##PRM:SMS_G_System_SoftwareFile.CreationDate## order by SMS_G_System_CollectedFile.FileName
It wil prompt you for the filename. size and creation date.
If that's too much criteria, you can change it.
Good Luck!
select SMS_G_System_CollectedFile.FileName from SMS_R_System inner join SMS_G_System_CollectedFile on SMS_G_System_CollectedFile.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = ##PRM:SMS_G_System_SoftwareFile.FileName## and SMS_G_System_SoftwareFile.CreationDate = ##PRM:SMS_G_System_SoftwareFile.CreationDate## order by SMS_G_System_CollectedFile.FileName
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question