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:


  


Real Time - Query !

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

Logged in as: Guest
  Printable Version
All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> Real Time - Query ! Page: [1]
Login
Message << Older Topic   Newer Topic >>
Real Time - Query ! - 8/22/2008 4:14:15 AM   
ridvan

 

Posts: 70
Score: -7
Joined: 3/13/2008
Status: offline 		Real Time - Query !

I Made one query, for retriving information, reagardin one software that is installed on some of Computers,

Ok The query results was 100% true... and helped me alot to identify the computers with those softwares, and i uninstalled the software,

But the problem is... after i Uninstalled softwares in all Computers... i made a same query and it still gives me the HostName of those computer that already uninstalled the Software,

So is there any way, that the query to be something like "real time" (and where exactly the query takes those infos, about PC-s) Can i clear it those saved datas, or something like that,

Regards,
Ridvan

< Message edited by ridvan -- 8/22/2008 4:23:16 AM >
Post #: 1
RE: Real Time - Query ! - 8/22/2008 6:12:23 AM   
skissinger


Posts: 2119
Score: 134
Joined: 9/13/2001
From: Sherry Kissinger
Status: offline 		What's the query?  Depending upon if the query relies upon Software Inventory data, or Hardware Inventory data, you will need to wait until those clients send up an inventory to update the database.

_____________________________

mofmaster@smsexpert.com (version 2007) | http://www.smsexpert.com | http://www.sccmexpert.com
My Blog
Microsoft MVP - ConfigMgr

(in reply to ridvan)
Post #: 2
RE: Real Time - Query ! - 8/22/2008 7:05:58 AM   
ridvan

 

Posts: 70
Score: -7
Joined: 3/13/2008
Status: offline 		Hi Skissinger, and all others,

The query is Sowftware based, (As i mention before)

(in reply to skissinger)
Post #: 3
RE: Real Time - Query ! - 8/22/2008 7:43:34 AM   
gjones


Posts: 824
Score: 50
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline 		Just to be clear, are you basing you query on Add/Remove programs data or Software files data?  

BTW once the programs have been un-installed force the appropriate inventory cycle to occur , usually Hardware inventory cycle.


_____________________________

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 ridvan)
Post #: 4
RE: Real Time - Query ! - 8/22/2008 7:51:43 AM   
ridvan

 

Posts: 70
Score: -7
Joined: 3/13/2008
Status: offline 		I Dont think that i need to do force HardWare inventory, because it is Software Report,

select SMS_R_System.Name from  SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SERVICE.DisplayName like "DameWare Mini Remote Control"

...which is the best way, to force software inventory.

Regards,
Ridvan

(in reply to gjones)
Post #: 5
RE: Real Time - Query ! - 8/22/2008 8:35:03 AM   
mhudson

 

Posts: 541
Score: 12
Joined: 4/1/2007
From: College Station, TX
Status: offline 		To get what you want you will need to perform a Software Inventory at the end of the install.  So you need to chain the install or place it in a batch, cmd or other file.  So when the install completes then the inventory will kick off.  Now when you run you query say 1 hour later it will be "up-to-date"  The problem is that HW/SW Inventory is a snapshot in time, not a realtime view of the client.


_____________________________

Matthew Hudson
http://sms-hints-tricks.blogspot.com/
http://www.sccm-tools.com

(in reply to ridvan)
Post #: 6
RE: Real Time - Query ! - 8/22/2008 8:49:54 AM   
ridvan

 

Posts: 70
Score: -7
Joined: 3/13/2008
Status: offline 		Mhudson,

That what you saying, sounds very nice... but the question is how to do that :) (did you done that in practice, if yes please share your experience)

Regards,
Ridvan

(in reply to mhudson)
Post #: 7
RE: Real Time - Query ! - 8/22/2008 9:11:48 AM   
mhudson

 

Posts: 541
Score: 12
Joined: 4/1/2007
From: College Station, TX
Status: offline 		We just did it for one of our upgrades.   For instance we have a adv that runs every day for the upgrade.
---LF upgrade.bat    ------
msexiec /i xxx.msi /q
if NOT %ERRORLEVEL%==0 set err= %ERRORLEVEL%
Iventory.vbs
rem exit the batch file with the error code so it is passed correctly
exit /B  %err%
------

So after the install runs it kicks off the inventory.

---- Inventory.vbs---

On Error Resume Next
Dim oCPAppletMgr
Set oCPAppletMgr = CreateObject("CPApplet.CPAppletMgr")
Dim oClientActions
Set oClientActions = oCPAppletMgr.GetClientActions()
Dim oClientAction
For Each oClientAction In oClientActions
    If oClientAction.Name = "Software Inventory Collection Cycle" Then
       oClientAction.PerformAction 
   End If
    If oClientAction.Name = "Hardware Inventory Collection Cycle" Then
       oClientAction.PerformAction 
   End If
Next
----------------

This actually kicks off both inventories so we can check Add/remove programs as well as the  xyz.exe file for version.

Now if the install crashes out then the inventory will still run and we pass the error level out the batch file
--this is a simplified version of what we have done but the principle is there.



_____________________________

Matthew Hudson
http://sms-hints-tricks.blogspot.com/
http://www.sccm-tools.com

(in reply to ridvan)
Post #: 8
RE: Real Time - Query ! - 8/22/2008 9:46:00 AM   
gjones


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

ORIGINAL: ridvan

I Dont think that i need to do force HardWare inventory, because it is Software Report,

select SMS_R_System.Name from  SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SERVICE.DisplayName like "DameWare Mini Remote Control"


This informaiton is from Hareware inventory not Software.

_____________________________

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 ridvan)
Post #: 9
RE: Real Time - Query ! - 8/22/2008 11:19:15 AM   
ridvan

 

Posts: 70
Score: -7
Joined: 3/13/2008
Status: offline 		Thanks to all guys,

I wil try this VBS by mhudson, and see what is happening,

Regards,
Ridvan

(in reply to gjones)
Post #: 10
RE: Real Time - Query ! - 8/22/2008 11:49:24 AM   
skissinger


Posts: 2119
Score: 134
Joined: 9/13/2001
From: Sherry Kissinger
Status: offline 		Just to throw some light on Inventory, Ridvan, I know it doesn't sound like it makes sense, that the Services you are querying are based off of Hardware Inventory data, but that's where that particular data point comes from.  software Inventory pulls back some information about actual files on the hard drive.  Hardware inventory pulls back information from the registry and WMI.  For services information, that information originates out of WMI for Hardware Inventory reporting, and that's why it's actually a Hardware Inventory Action you need, not a Software Inventory action to update that information from the client to the server.

Makes sense?  or did I just muddy the waters?

_____________________________

mofmaster@smsexpert.com (version 2007) | http://www.smsexpert.com | http://www.sccmexpert.com
My Blog
Microsoft MVP - ConfigMgr

(in reply to ridvan)
Post #: 11
RE: Real Time - Query ! - 8/22/2008 11:56:04 AM   
ridvan

 

Posts: 70
Score: -7
Joined: 3/13/2008
Status: offline 		Actually i am really confused about this one, HW and SW Inventory... Services to be count as HW Inventory, it's really weird. but in Microsoft everything is possible :)

I have one book for SCCM 2007, and i am going to try to find something usefull, that really defines what is and what is not HW/SW inventory

Skissinger, your explanation makes sense...

Regards,
Ridvan

(in reply to skissinger)
Post #: 12
RE: Real Time - Query ! - 8/23/2008 9:28:17 AM   
mhudson

 

Posts: 541
Score: 12
Joined: 4/1/2007
From: College Station, TX
Status: offline 		Here is the document that you ...This tells you what is software and what is hardware inventory

http://technet.microsoft.com/en-us/library/cc180445.aspx



_____________________________

Matthew Hudson
http://sms-hints-tricks.blogspot.com/
http://www.sccm-tools.com

(in reply to ridvan)
Post #: 13
RE: Real Time - Query ! - 8/23/2008 10:05:49 AM   
ridvan

 

Posts: 70
Score: -7
Joined: 3/13/2008
Status: offline 		Mhudson and others :) thnx for infos, 
Thnx 2 all
Ridvan

< Message edited by ridvan -- 8/23/2008 10:06:41 AM >

(in reply to mhudson)
Post #: 14
Page:   [1]
All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> Real Time - Query ! 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.391