Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

SMS Query for user accounts on client computers

SMS Query for user accounts on client computers

SMS Query for user accounts on client computers

I am looking for help in writing a query for user accounts on client computers.  I believe that this information is in Win32_Account, and have edited my sms_def.mof file to include parts of it. Inventory has run with the new defmof file. I havnt had any success writing queries against Win32_Account.  Has anyone done this?   Thanks   Jon

RE: SMS Query for user accounts on client computers

Are you trying to create a query in the SMS Admin Console, or are you trying to run a query against thw WMI layer?

If you are in the admin console and the fields are simply not listed in the drop down boxes, then either your MOF didn't work, or you need to choose a different base class in the very first "Create Query" dialog box.

If you are trying to script a query (essentially Ad-Hoc), then you should use WMI CIM Studio to browse the WMI namespace on the server to find the tables and see if there is any valid data being reported.

When editing the SMS_Def.MOF file, you should ALWAYS test the MOF file by running (in a dos window) "MOFCOMP.EXE SMS_Def.MOF".  This will tell you if there are syntax errors.  If there are syntax errors, then the data isn't getting retrieved from the client.

Overall, I would say you should figure out if it's breaking at the client (use MOFCOMP.exe), or if it's breaking at the server (use WMI CIM Studio).

RE: SMS Query for user accounts on client computers

Since the updated MOF is alread deployed, check the client's hardware inventory log for any error messages concerning the section you've added to the SMS_DEF.MOF.

Make sure you've followed the instructions here:


While this pertains to the MOF files submitted by the SMS community, you should verify your MOF file has made it through its process.

Rod Trent
Microsoft SMS Installer ISBN:0072124474
Admin911:SMS ISBN:0072130229
IIS 5.0: A Beginner's Guide - ISBN:0072133724

RE: SMS Query for user accounts on client computers

Thanks for the help. It was dead on.  The HINV log showed that the new MOF file never made it to the client.  MOFCOMP showed compile errors, which were caused by my not having the current ver of MOFMAN.   Jon

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close