myITforum.com Community Forum myITforum.com Community Forum

Home  Forums  Blogs  Live Support chat  Search Articles  Wiki  FAQ  Email Lists  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

All Forums RSS Feed Subscription:


  


I need to run two query on pcs with GL Inquiry Suite Enterprise Version 6 and GL Inquiry Suite Enter

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
  Printable Version
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> I need to run two query on pcs with GL Inquiry Suite Enterprise Version 6 and GL Inquiry Suite Enter Page: [1]
Login
Message << Older Topic   Newer Topic >>
I need to run two query on pcs with GL Inquiry Suite En... - 9/12/2008 2:58:10 AM   
nkobas

 

Posts: 14
Score: 0
Joined: 6/24/2008
Status: offline 		Hi,

I need to run two query on pcs with GL Inquiry Suite Enterprise Version 6 and GL Inquiry Suite Enterprise Version 7 installed.
I looked in Add or Remove Programs on pcs with Ver 6 and Ver 7 which both display "Inquiry Suite."
I then looked in the Registry and found different reg keys -
6.1.7
7.2.3.1
Can someone please help in creating a query on reg keys or whatever works?

Thanks
Post #: 1
RE: I need to run two query on pcs with GL Inquiry Suit... - 9/12/2008 8:00:17 AM   
gjones


Posts: 903
Score: 60
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline 		This Information is already stored within the Security logs, Have you looked exporting it from there?

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx


(in reply to nkobas)
Post #: 2
RE: I need to run two query on pcs with GL Inquiry Suit... - 9/15/2008 1:19:22 AM   
nkobas

 

Posts: 14
Score: 0
Joined: 6/24/2008
Status: offline 		Garth,
I looked on my pc and another pcs security log files which had only one log.
Description:
The audit log was cleared
Primary User Name: SYSTEM
Primary Domain: NT AUTHORITY
Primary Logon ID: (0x0,0x3E7)
Client User Name: SYSTEM
Client Domain: NT AUTHORITY
Client Logon ID: (0x0,0x3E7)
 
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
 
Do you have a query statement I can copy and paste please?
Thanks
nkobas
 
 

(in reply to gjones)
Post #: 3
RE: I need to run two query on pcs with GL Inquiry Suit... - 9/15/2008 7:41:40 AM   
fault

 

Posts: 40
Score: 2
Joined: 7/21/2008
Status: offline 		I'm not sure what Garth is referring to. Maybe he accidentally replied to the wrong post? :(

SMS doesn't collect registry information by default. But you can achieve what you want via a few different methods:
  1. Extend sms_def.mof file to collect the registry key (never done this before myself but have seen some other posts on it as an option? probably not the best option anyway in this case)
  2. Write a script (that you deploy via software distribution) that collects the registry key (if it exists) and write the value to a file that you collect with software inventory (more work & messy, plus why bother with the trouble when you have the next option...)
  3. Write a WQL query to report the file version (collected by software inventory - you do use it right? :P) for the application's executable
Example:

select SMS_R_System.NetbiosName, SMS_G_System_SoftwareFile.FileVersion, SMS_G_System_SoftwareFile.FileName
from SMS_G_System_SoftwareFile
inner join SMS_R_System
on SMS_R_System.ResourceId = SMS_G_System_SoftwareFile.ResourceID
where SMS_G_System_SoftwareFile.FileName = "MYPROGRAM.EXE"

Once you know what the SMS_G_System_SoftwareFile.FileVersion field reports, you can create the two separate collections by adding AND SMS_G_System_SoftwareFile.FileVersion = ... to your WHERE clause. Hope that helps :)

< Message edited by fault -- 9/15/2008 7:43:54 AM >

(in reply to nkobas)
Post #: 4
RE: I need to run two query on pcs with GL Inquiry Suit... - 9/15/2008 8:40:24 AM   
gjones


Posts: 903
Score: 60
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline 		I did !! :-)

Now let me re-read this thread and I will get back to you in a few minutes.

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx


(in reply to fault)
Post #: 5
RE: I need to run two query on pcs with GL Inquiry Suit... - 9/15/2008 8:53:39 AM   
gjones


Posts: 903
Score: 60
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline 		By default SMS / ConfigMgr does pickup the Version numbers for application within the Add / Remove programs.
 
The blog post should help you.
http://smsug.ca/blogs/garth_jones/archive/2007/05/08/subset-query.aspx

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx


(in reply to nkobas)
Post #: 6
RE: I need to run two query on pcs with GL Inquiry Suit... - 9/15/2008 5:39:13 PM   
fault

 

Posts: 40
Score: 2
Joined: 7/21/2008
Status: offline 		Hey Garth :) Nice post - didn't know that ARP kept version information! Very useful!

However I don't agree with your WQL examples (click "WQL (tomorrow)" at the bottom of your above link, or direct link here http://smsug.ca/blogs/garth_jones/archive/2007/05/10/303.aspx; I separated each part of your WQL for readability):

select distinct SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID
from SMS_G_System_ADD_REMOVE_PROGRAMS
where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Visio 12"

I think you want to query the SMS_G_System_ADD_REMOVE_PROGRAMS.Version for the version information! E.g., for "Visio 12":

select SMS_R_System.ResourceID, SMS_R_System.Name, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS.Version
from SMS_R_System
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 "%VISIO%"
and SMS_G_System_ADD_REMOVE_PROGRAMS.Version like "12%"

Note: If anyone does happen to try and copy this WQL to get Visio 12 results, you'll need to do another sub select query to filter out "Microsoft Office Visio MUI (English) 2007" (or whatever other language you've installed?) in the DisplayName column as that seems to comes through for me with "Microsoft Office Visio Professional 2007" in my case (duplicate information!). But you shouldn't have to worry about this for your GL Inquiry Suite query nkobas!

< Message edited by fault -- 9/15/2008 5:40:45 PM >

(in reply to gjones)
Post #: 7
RE: I need to run two query on pcs with GL Inquiry Suit... - 9/15/2008 9:07:34 PM   
gjones


Posts: 903
Score: 60
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline 		It was just an example, Yes you could use the version number field to filter the data. The point is really to understand the data, then writing the query is much easier.
 
BTW like with SQL queries I stay away from the SMS_R_System views (v_R_System for SQL). I might use them for some of my collections but other than that I almost never use either view as they are too unreliable.   Waiting  for John to pop his head in and disagree.


_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx


(in reply to fault)
Post #: 8
RE: I need to run two query on pcs with GL Inquiry Suit... - 9/16/2008 12:14:15 PM   
jnelson993


Posts: 959
Score: 132
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		Again with the SMS_R_System/v_R_System thing!!  What is it with you?

Those are required in my book if you want to remove obsolete & decommissioned records (and who doesn't ?), but I guess aren't that big of a deal if you're not doing decommissioning and are joining to SMS_G_System, or if you are linking to v_FullCollectionMembership and are already removing obsolete and decommissioned records through that collection query.

If you don't know what I just said, then let me know...



_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to gjones)
Post #: 9
RE: I need to run two query on pcs with GL Inquiry Suit... - 9/16/2008 1:12:44 PM   
gjones


Posts: 903
Score: 60
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline
quote:

ORIGINAL: jnelson993
If you don't know what I just said, then let me know...


Ok, I don't know what you said..

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx


(in reply to jnelson993)
Post #: 10
RE: I need to run two query on pcs with GL Inquiry Suit... - 9/17/2008 8:42:56 PM   
nkobas

 

Posts: 14
Score: 0
Joined: 6/24/2008
Status: offline 		Worked great!!!
Excellent help!!!

Thanks
gjones
fault
jnelson993


(in reply to gjones)
Post #: 11
Page:   [1]
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> I need to run two query on pcs with GL Inquiry Suite Enterprise Version 6 and GL Inquiry Suite Enter Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts



  
Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.422