GarthMJ

Why no use the CM12 power management option to do this?

Ok, I will bite, why do you think that removing old package will affect live packages? All I do is once I determine a package is no longer needed. I remove all adverts, remove it from all DPs (not necessary but I like to do this step), delete the package.

You are getting access denied because you are querying the tables instead of the views, by default none of the reporting options within CM07 or CM12 have permissions to any of the table data. BTW, It is bad form to query the tables directly and can lead to table locking issue on a busy site.

This should get you started. http://smsug.ca/blogs/garth_jones/archive/2009/04/22/using-datediff-amp-getdate-in-wql.aspx

The same isses exist within CM12 too. Again there is a way to ensure that all values are displied.

Have you tried this. http://technet.microsoft.com/en-us/library/bb632403.aspx

The query above works.... So Fr0zen, how to what?

I’m sure that you can do this the question is how do you determine that a PC is newly deployed? Any of the ideas that I have will NOT guarantee that all PCs have are brand newly images but they will be new to CM07/CM12 BTW why not install them as part of your Task Sequence?

What ultimately are you trying to get out of this? What SU have been applied to each WS? OR what SU have been deployed?

Have you looked at the Alerting feature within CM12, yet?

Yes that query can be used to create CM12 report. Create the report just as you would for any other report.

Here you go. http://smsug.ca/blogs/garth_jones/archive/2012/11/09/list-all-mac-address-with-service-names.aspx

Err.. I will disagree with you on ARP details. Almost every application use ARP, it is one of the requirement to get your application certified for Windows.

What is wrong with uisng the built-in report call "Count of all instances of software registered with Add or Remove Programs"?

I hate to say this but if you are working with CSS, you should continue working with them to resolve all of your issues. The main reason for this is that anything that we say or tell you to do. I might step on what the CSS team are trying to do and therefore it might take longer to get things fixed. Plus the CSS team will likely be faster at fixing your issues then the forums.

This is really an AD question not a CM07/CM12 question. AD is the only thing that can tell you who was the last on to logon to a PC and when that was. OpsMgr can help with that if you use ACS.

It is not support to have two PC with the same NetBIOS name within CM12. Your only option is to rename this PCs to have a unique NetBIOS Name.

Although theoretically possible, this would NOT make good sense. The reason is simple if you have a CAS all data from ALL companies would be replicated between all primary server. This would mean that anyone at any companies could see data from the other companies. Even worse yet, if any of those companies do any management task, they could affect the other companies. From a security stand point will never get approved.

CM07 is NOT the going to help you with this. The only way you are going to get that data is from AD. OM07/ OM12 would be better suited for this or a standard DSQuery.

There is your first problem. You are run PoSH script. :-) The answer is: you are comparing apples and oranges. This PoSH script is query the CI for SU, the WQL query is comparing the CI for DCM.

Why do you say the query is not working? It looks fine to me..

Actually you could not add IP address to a collection in CM07. You could add IP address to either a query or a report in CM07, however I almost always recommend not adding IP addresses. You still can't add IP adress in CM12 either.

I hate to say it but for urgent issues like this, you should call CSS for support. They are the best ones to help you in a timely fashion.

I’m sure that you can wmic but I use Wbemtest instead, particularly since it will allow me to connect to remote PCs.

V_GS_Add_Remove_Programs will only give you 32bit PCs, use v_Add_Remove_Programs, instead it will give you both x64 and x86.