New To SMS 2003 and trying to run a Query
Hi,
Sorry to bother you but I was wanting to get some help. I have begun to take on the role of SMS admin at my workplace and have taken some classes. I was recently asked to generate a report, but I am having trouble getting exactly what they want.
Here is what they want to know:
They want a list of every application installed (especially if they have multiple versions) on all the systems at the site (or sub collection). They don't need it to be PER system, just an overall list....
They don't want the list to include office 2003 apps, drivers, or patches (office or windows).
I assume this needs to be a query run against the database that looks at Add/Remove Programs.
Not sure how to do this and put it a format that the manager types can use.
Thanks for your help!!!!!!!
Sorry to bother you but I was wanting to get some help. I have begun to take on the role of SMS admin at my workplace and have taken some classes. I was recently asked to generate a report, but I am having trouble getting exactly what they want.
Here is what they want to know:
They want a list of every application installed (especially if they have multiple versions) on all the systems at the site (or sub collection). They don't need it to be PER system, just an overall list....
They don't want the list to include office 2003 apps, drivers, or patches (office or windows).
I assume this needs to be a query run against the database that looks at Add/Remove Programs.
Not sure how to do this and put it a format that the manager types can use.
Thanks for your help!!!!!!!
0 Comments
[ + ] Show comments
Answers (3)
Please log in to answer
Posted by:
ColeenC
16 years ago
[font="courier new"]
[font="courier new"]
[font="courier new"]
[font="courier new"]
[font="courier new"]
[font="courier new"]
Posted by:
miclarke
16 years ago
I am currently working with 2 clients looking for individuals who are strong in SMS and Group Policy, both are permanent positions and one is working with the Olympics, and driving the IT infrastructure behind it. If interested please email me at [email=miclarke@teksystems.com]miclarke@teksystems.com[/email]. Any referrals are also appreciated.
Cheers,
Cheers,
Posted by:
AngelD
16 years ago
miclarke,
Use the "Job Board" forum for recruitment!
Stick to the rules or you may get "banned"
/Kim
Use the "Job Board" forum for recruitment!
Stick to the rules or you may get "banned"
/Kim
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.