GarthMJ

The column to add for user name is sys.user_name0 to your query above.

Your best bet is to contact 1E, support. They will tell you exactly how to do it in a supported manner. Correctly me if I'm wrong but Nomad can be configured to use a percentage of the network bandwidth.

Divide by 1024 to get MB/GB.

No idea why it is not installed. Have you looked at the logs file to file out why?

Look at your screen above notice that you have yet to install the CM12 client on that computer. Notice it say Client No for WP06i002

Did you notice that WP06i002 is not a CM12 Client yet. I would look at fixing that.

It is not a silly question, I use too many acronyms. ;-) BIDS = SQL Server Business Intelligence Development Studio. It is similar to Report Builder but I has a bit more functionality.

There is no trick to this. You need to create a custom report (I recommend BIDS), which in the case is your dashboard. To make it useful make sure you included drill downs to show details for the data. For example you can create a dashboard like this http://www.enhansoft.com/blog/new-system-center-endpoint-protection-scep-ssrs-reports-webcast, then drill down to another report detail report.

So what you try to use the report above to do what you want then? There are lots of examples on my blog of queries with collections.

This will help you. http://www.enhansoft.com/blog/how-to-perform-a-full-hardware-inventory-for-a-pc-collection-the-easy-way

Is the MP listed in the log file the correct one? If it is then you need to re-check your CM12 client package and ensure that all the setting are correct.

How exactly did you setup you adr?

The error say there are no DP available. Have you deploy the CM12 client to your DPs? Have you enable the Failback option on the package?

For SQL issues, you should contact Microsoft support directly for support. Editing the database is unsupported with CSS help.

Client push is perfect it doesn't need the AD container. As to why client push is not working look at the ccm.log to find the error.

There isn't much to tell, once the client are assigned, it will just work. As for assigned the site there again is much to tell either, but it will depend on how you are installing the client. So how are you installing the client?

IMO I see no reason why the AD admin shouldn’t give your or SCCM full access rights to the System Management container. What is the worst thing that can happen? You delete all the object form the container? So what they will get automatic get recreated within a few minutes. Yes you can use SCCM without accessing the System Management container, it just means that your client will not be able to automatically assign themselves to your site. It also means that they will not able about to locate content locations from AD, instead they will use the MP.

Which setting you do enable? When did you enable it? How are you creating this list of software?

From what I can see from your screenshot there is nothing wrong with your DP. You have already deploy the image to it. Are you trying to update the Image?

use this blog post to find the problem http://www.enhansoft.com/blog/troubleshooting-inventory-flow

I hate to say it but it is really hard to answer questions like this in a forum. There are just too many vars., except is very rare cases, NO CAS! Take Brandon: What create a secondary in Brandon, MB? (BTW I have been there and Virden MB too! Hi from Ottawa) How any users/computers are there? What is the network like? (is it slow, do we need to protect the site, if so why? etc.) Are there any techs there? How much bandwidth is there? Is there anything special about this site? What SLA do you have in Place? How are you planning on do patching? What percentage are you clients model? What OS is installed at these sites? Etc. For CM12 How often are you preform HW inventory? What about upgrading OS? Etc. CM12 is a huge product and I would personally recommend that you hire a consultant with experience, work with them to create the design. The key is work with them more as a mentor than a contractor. That is my two Canadian cents.

Take a look at SYDI. This is what I use. http://sydiproject.com/

What you are asking for is a ton a data, instead look at this report. http://smsug.ca/blogs/garth_jones/archive/2009/02/25/patch-compliance-progression-report.aspx

I think you want to look at SCOM not SCCM.

Hi Rob yes you can do that with SSRS, it would be a custom report or dashboard that you will need to setup.