GarthMJ

30 GB is a tiny drive size. If this a VM why not use a Dynamic VHD set to 128 GB or something like that. Now is that 30GB just for SQL or is that 30GB for SQL and all its database? My 20 PC lab have a db of ~10GB. For production db, it will depend alot on how many PCs you have, so How many PCs will you have?

That query does not use SW inv for it data, it use HW inv. But again why not use Software Update to deploy this SU?

Why don’t you use Software Update for deploying this SU update? You can change you HW inventory cycle to daily and therefore it will take 24 hours for everyone to start reporting updated data back to CM12/CM07.

This is not answer your question directly, but one of my client created a web interface to allow the Service Desk to delete PC from CM07/CM12. Since it was a web interface security was control at the website and one 1 account has access to CM07/CM12. Also by using the web interface they controlled what they could see there too.

There is no simple way to do this, you would need to write your own application/add-on for the CM12 console.

IMO, 800 MB is not enough free space on C:\, IMO you should have a minimum of 100 GB (total space) on C:\. Otherwise you will have problem with SU and will constantly be cleaning the C:\ to get more space. You can query WMI to get the physical Ram then you can multiple that by 1.5.

Did you rename the server after installing SQL? Is both the CM12 database and the SQL server SQL_Latin1_General_CP1_CI_AS collation?

That would be Heartbeat discovery and it should never been turned off.

Here you go. http://technet.microsoft.com/en-ca/library/gg682077.aspx

How many primary sites will you have? Will you have a CAS? To quote the docs "When you use SQL Server Standard for the database at the central administration site, the hierarchy can only support up to 50,000 clients." And there is NO way to upgrade from standard database format to Enterprise database format. If you don’t' have a CAS then you don't need to worry about this until you hit 100k users.

What you have there already list the last user logon as of the last heartbeat. The only way to add last time a user used the console is to add System Console User to the query. This complicates the query as the view needs to be enable first (AI class) and most PC will have more than 1 user listed. To get it to one line/pc is not a simple task.

What do you mean by upgrade? What is the maximum number of clients you will ever have?

1) Yes it will work and IP Ranges is the preferred method for boundaries. If you where getting an erro is was most like because you had your boundaries setup incorrectly, generally this happen when AD or Subnet boundaries are used. 2) Yes that is a good plan that was you can protect DPs, this allow you to have better control over, which client use which DP.

try this. http://smsug.ca/blogs/garth_jones/archive/2013/01/11/wmi-query-for-c-with-more-than-1gb-of-hd-space.aspx

Sorry, no you can’t do that. Can I ask why you care?

We can’t definitively answer this question without your query. You need to post your query, before anyone can truly answer this. Based on the query and how it was written, you will need to check you ARP data too, to confirm that the arp data is unique from the older version.

CM07 server must be administrator on the remote server always, otherwise your backup will not work. This is one of the reason why I NEVER recommend remote SQL.

It is the same in CM12, However with SSRS reporting you can make it one big report. It did that for a client.

Why not use the NON AI report for OS details Count operating system versions. Personally I don’t use the AI due to the AI being unreliable.

This KB will help you get started. http://support.microsoft.com/kb/944375/en-us?p=1

AI doesn't using Software Inventory at all. So there is no need to enabled it at all.

So this tell me that there is a problem with your MP. Confirm that the service is running. Reboot the server If that doesn't fix it , Re-install the MP.

Have you installed all the AI software updates? This is one of the issue with AI.

Read this article, where does HW inventory stop? http://www.myitforum.com/articles/8/view.asp?id=11236

IMO this issue is likely because the CM07/CM12 client is not installed on these PCs. The PCs have been discovered by CM via AD discovery but the CM client has not be installed.