GarthMJ

What is your hardware inventory schedule? Why do you care who was the last user login to the computer?

if you review the status messages it will give you suggestions for each error have you done these suggestions?

Now that I'm back in the office and can look at this. Both queries will return the same results. Both queries will use the last login user when your Hardware inventory last occurred. If no one was login when HW inventory occurred, it would be null.

This query will only show you computers who last logon user was X.

What does your query look like ?

Without your query, there isn't a lot anyone can do to help you.

There is no where near enough details to give you any useful insight. You have not answered any of my questions either. Again there is no product call SCCM 2016. You must be looking at CMCB.

Why do you need a separate management console for servers and desktops? Why can't you have one console and use Role Based administration? Why is wrong with you exist environment? Honestly no one can answer this without knowing a lot more details. As such it might be worth hiring a consultant to help out. Note that there is no product called SCCM 2016. Therefor you must have CMCB

There is no such things an a MP proxy. Your only solution is to allow clients at your secondary site to access the MP at the primary site. All of this is covered within the documentation for CMCB.

Remember just because a SU was applied doesn't mean it is installed or still installed or will install again. There isn't a report that will show you just there are report that will show what is installed and not installed for a computer.

QFE, does not listed all SU so understand that it will/can be missing some. Since CM applied the SU it shouldn't be behind on what was installed more than 15 minutes (default setting). I'm not following you as to how this will all be used together.

Have you looked at the built-in reports?

So what does you query look like now?

Advanced Installer is great and is it even cheaper than PACE!

You should look at Advanced installer, it is prices right.

You can't merge them. At best you can migrate their app and package to the new CMCB site. No you don't need to extend the schema again. There are no attribute chagnes in CMCB.

if all you do is update the content, then it will NOT affect these already installed.

0x87d00217 = Data is corrupt So.... check your site health including AD.

So what have you done to troubleshoot this? What error message are you getting? do the reports work outside of CM console?

I'm always around to answer questions but I'm a bit busy with MS Ignite stuff... If you are at Ignite, feel free to stop by the booth 1246 or if you are going to IT/Dev in Oct, say stop me and say Hi.

ok, I will bite, if the exe updates every 14 days, why don't you force it to upgrade any week? Why jump thur the extra hoops? I would not set the policies to check every 10 minutes, you are begging for trouble.

why don't you post the solution for other to find? Either here or on your own blog with a link here.

BTW, after re-reading the above, It is unclear to me if you uninstall IIS and rebooted. then Re-installed IIS.

What CM services account at you talking? CM uses the computer account for just about everything. Does the CM site server computer account have full admin and SA rights to SQL?

First off nothing within the CM database or WMI can every be used for forensics investigations and have it hold up in any court. On a side note, there are assumption within the first blog that are incorrect. CCM_RecentlyUsedApps will not tell you about deleted files. It will only tell you what was executed only. But by doing a comparison you can determine what executables have bene deleted or rename but nothing else. More than just SW metering needs to be enable the AI class also needs to be enabled too. AI data is collected based on the Hardware Inventory cycle default is 7 days BUT most senior SCCM admins will recommend daily. Not all apps are tracked by CCM_RecentlyUsedApps, you can see this from the log file. In my quick tests, the execution user is incorrectly identified, only the logon user (I assume console user) is shown as show executed the app.