System Center Configuration Manager TechCenter >
System Center Configuration Manager Forums
>
Configuration Manager Inventory
>
Change to SQL view v_R_System?
Change to SQL view v_R_System?
- In my SMS days, I found that I always had better reporting for the last logged on user from our discovery cycles using the view - as opposed to using v_GS_ComputerSystem, which only had information obtained during a HINV cycle, which if no user was logged into Windows, then no inventory would be gathered.
However, now with SCCM, we're finding that the view is getting last logged on user from the same table that the view v_GS_ComputerSystem does. Was there a change to the SQL view v_R_System from SMS 2003 to SCCM 2007? Or am I just mis-remembering?
Nick Moseley - SCCM Admin http://t3chn1ck.wordpress.com
Answers
- I think v_r_system still relies on heartbeat... but whatever.
How about this: http://smsug.ca/blogs/garth_jones/archive/2008/02/22/location-of-last-logon-user.aspx
or check out Garth's argument about v_gs_computersystem: http://smsug.ca/blogs/garth_jones/archive/2007/03/22/224.aspx
but John Nelson argues for v_R_system_valid.
and different people might argue that neither v_gs_computersystem, nor v_r_system_valid are the optimal places, you should rely on the Console Usage reports to get the best "who does this pc belong to" correlation.
I like to offer people Garth's Location of last logon user (the top link of all potential locations) and let you decide what you think is the best location for your environment.
Standardize. Simplify. Automate.- Marked As Answer bynickmo Thursday, November 05, 2009 7:13 PM
All Replies
- I think v_r_system still relies on heartbeat... but whatever.
How about this: http://smsug.ca/blogs/garth_jones/archive/2008/02/22/location-of-last-logon-user.aspx
or check out Garth's argument about v_gs_computersystem: http://smsug.ca/blogs/garth_jones/archive/2007/03/22/224.aspx
but John Nelson argues for v_R_system_valid.
and different people might argue that neither v_gs_computersystem, nor v_r_system_valid are the optimal places, you should rely on the Console Usage reports to get the best "who does this pc belong to" correlation.
I like to offer people Garth's Location of last logon user (the top link of all potential locations) and let you decide what you think is the best location for your environment.
Standardize. Simplify. Automate.- Marked As Answer bynickmo Thursday, November 05, 2009 7:13 PM
- From my quick look at the SQL views, they look the same as they did in SMS 2k3.
http://www.enhansoft.com/
