Jump to content


  • 0
Dmitry Shumov

How to get a inventory report with user full name and user's OU information

Question

3 answers to this question

Recommended Posts

  • 0

OK absolute noob here. I've been "learning" SCCM 2007 for about a year and while I can do a lot of things, I cannot script so I am forced to dig out stuff from those of you online who generously share your knowledge.

I am diving into reports and queries but struggle with doing a copy paste of these reports and having them function without error. I am copy/pasting to word pad and then trying to paste it in to sccm but seems like it never works. My assumption is that I am not addressing or qualifying the tables that are being used. simply pasting the SQL statement: is not enough correct? I down loaded a utility - Creating Custom Reports By Using SQL Views but its a huge struggle if you don't know SQL.

 

My goal is to get one that shows me all devices that are member's of more than one collection and I would like, having now found it, to use this All-in-one report.

jm

Share this post


Link to post
Share on other sites

  • 0

by default,client is member of more than one collections i,e member of default collections. what are you trying to achieve by knowing client is member multiple collections ?

you can try looking at this report to know client is member of what collections instead of all clients. http://eskonr.com/2009/07/sccm-report-computers-member-of-which-collection/

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.