Re: SMS Query for Registry Key?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Try this...
http://smsug.ca/blogs/garth_jones/archive/2008/04/10/env-with-pc-info.aspx


"Barkley Bees" <barkbees@xxxxxxxxxx> wrote in message news:uTOFUSrmIHA.5208@xxxxxxxxxxxxxxxxxxxxxxx
Thanks very much Garth. It works fine when I changed the value "TMP" to "Version", outputting the the desired data. Yes, you're right.....It would be good if I could match the output data to the system names =). I have tried to integrate this to an existing report (see the lines prefixed with *** for example), but to no avail:

-------------------
select distinct v_R_System.Netbios_Name0 AS "Computer Name"
, v_R_System.User_Name0 AS "Last Logged on User"
, v_R_System.User_Domain0 AS "Domain"
, v_R_System.Operating_System_Name_and0 AS "Operating System"
, v_gs_Operating_system.csdversion0 AS "Service Pack Level"
, v_gs_pc_bios.serialnumber0 AS "Serial Number"
, v_GS_Computer_system.manufacturer0 AS "Manufacturer"
, v_GS_Computer_system.model0 AS "Model"
, v_GS_x86_PC_memory.totalphysicalmemory0 AS "Memory (KBytes)"
, v_gs_processor.maxclockspeed0 AS "Processor (GHz)"
, v_GS_LOGICAL_DISK.size0 AS "Disk Space (MB)"
, v_GS_LOGICAL_DISK.FreeSpace0 AS "Free Disk Space (MB)"
***, v_GS_ENVIRONMENT.Name0 AS "Image Version"


from v_R_System
inner join v_GS_Operating_system on (v_gs_operating_system.resourceid = v_R_system.resourceid)
inner join v_gs_PC_bios on (v_gs_pc_bios.resourceid = v_r_system.resourceid)
inner join v_gs_system_enclosure on (v_gs_system_enclosure.resourceid = v_r_system.resourceid)
inner join v_gs_computer_system on (v_gs_computer_system.resourceid = v_r_system.resourceid)
inner join v_GS_x86_PC_memory on (v_GS_x86_PC_memory.resourceid = v_r_system.resourceid)
inner join v_GS_processor on (v_GS_processor.resourceid = v_r_system.resourceid)
inner join v_GS_LOGICAL_DISK on (v_GS_LOGICAL_DISK.resourceid = v_r_system.resourceid)
where v_gs_logical_disk.deviceID0 = 'C:'
*** inner join v_GS_ENVIRONMENT on (v_GS_ENVIRONMENT.resourceid = v_r_system.resourceid)
*** where v_gs_environment.Name0 = 'Version'
Order by v_r_system.netbios_name0
-------------------

Any ideas?



"Garth" <Spam@xxxxxxx> wrote in message news:4DA6EAD6-4374-4A1E-A7FC-EF3BD516E386@xxxxxxxxxxxxxxxx
Here is a simple Report.... You will most likw want it to inclued computer name, if so let me know...
http://smsug.ca/blogs/garth_jones/archive/2008/04/09/environment-variable-query.aspx



"Barkley Bees" <barkbees@xxxxxxxxxx> wrote in message news:eozUUMgmIHA.3532@xxxxxxxxxxxxxxxxxxxxxxx
Hi Garth. Thanks for your follow up =). I have got SMS 2003 to inventory the Environment Variables on client machines (thanks to Sherry pointing me in the right direction - see below link). We are doing this because we have a custom entry set there to display the client OS image version (Variable - "Version", Value - "#######"). We would like to be able to see this in reports but I'm not sure how to go about doing this. I was able to create a Query to display the proper results as follows:

Criteria type: Simple value
Where: Environment - Name
Operator: is equal to
Value <string>: version

reference link: http://myitforum.com/cs2/blogs/skissinger/archive/2008/03/05/enabling-inventory-for-environment-variables-sms2003-configmgr.aspx

Appreciate your help. Thank you.

"Garth" <Spam@xxxxxxx> wrote in message news:D5EEF347-B00B-49D4-9178-D22848FF7347@xxxxxxxxxxxxxxxx
I'm only half following the thread :-) , I will have to go back and find out what you are trying to do. Give me a day or two to get back to you. Or you could post a summary for me.. :-)



"Kim Oppalfens [MVP]" <""Kim dot Oppalfens\"@google mail.com"> wrote in message news:OUyg3%23VmIHA.536@xxxxxxxxxxxxxxxxxxxxxxx

Not sure whether Garth has a Garth filter for posts, so you might want to start a new thread mentioning the word report in the subject :-)

Btw, I forgot to add that my focus point in these newsgroups is "sms 2003" and clustering.


Indeed! I have found the quality of posts in this newsgroup to be very useful in learning the SMS ropes. I wonder if Garth may have any insights on how one might build the above report? =)


--
"Everyone is an expert at something"
Kim Oppalfens - Sms Expert for lack of any other expertise
Windows Server System MVP - SMS
http://www.scug.be/blogs/sccm







.

Relevant Pages

  • Re: SMS Query for Registry Key?
    ... Thanks very much Garth. ... outputting the the desired data. ... to start a new thread mentioning the word report in the subject :-) ... I forgot to add that my focus point in these newsgroups is "sms ...
    (microsoft.public.sms.admin)
  • Re: Report Error
    ... Looking to get more involved in the SMS community? ... > It shows OK in reportinstall.log when Report is enable. ... > the IIS service manager and browse that web folder? ... installing. ...
    (microsoft.public.sms.admin)
  • Using Reports/Dashboards to import another ODBC connection
    ... We are using SMS 2003 in our infrastructure. ... of the things I was curious about was creating a custom report. ... database. ...
    (microsoft.public.sms.inventory)
  • RE: SMS 2003 Web Reporting
    ... Automate. ... "Brent Waddell" wrote: ... not show up in SMS web reporting. ... the report has additional criteria which will only be available ...
    (microsoft.public.sms.admin)
  • Re: Alarm if change or rob hardware success
    ... what I would do is create a report like this (this one is for memory ... Then schedule the report to run with an export to option ... > I like to monitor all me company, around 600 sms clients. ... >> Kim Oppalfens ...
    (microsoft.public.sms.admin)