GarthMJ

No there is no way to do that. What are you trying to do?

can you post the query that you have now?

It should work fine, if you only move the CM db. Remember you will need to do a site reset. There are details instruction within the docs on how to move the db.

If I remember right there are instruction within the docs that will tell you how to move the db from server to another server. No it will not include the WSUS db. No the CM12 reports will not work until you fix the SSRS site, if you had SSRS before you can adjust the old SSRS site to use the the new database.

Remember that the version number is an option item for Add/Remove programs. Therefore in this case it is not the best option for this.

If you DNS is good then there is nothing you really need to do. But I would recommend updating your Boundaries.

Actually this is really simple due to the way System OU discovery works. Tehre is no need to use the "is like" Just write the query for the Top level OU and all sub OU PC will automatically be included. Your Query will look very similar to this select * from SMS_R_System where SMS_R_System.SystemOUName = "GARTEK.TST/SERVER"

There are several way to inventory this, which method did you use? What does your query look like? Have you looked at those PCs to find out why, you are not getting the results that you expect?

I hate to tell you itguru1982 this but there are a number of thing wrong with your query. 1) Your join in incorrect. USR.ResourceID != SYS.ResourceID ; you can see this by changing you left join to a right join 2) The Last logon time that you are using is for the PC not the user.

You could point them to the Docs, It is stated clearly that CM07 backup task is the only supported backup and the CM07 server must have dbo and Administrator rights to the SQL server. Heck it even says that Remote SQL is NOT best practice too. I hate remote SQL! I add 15 days to any project with remote SQL!

You MUST use the CM07 Backup task, if you ever want to restore you site. There is no “if”, “and” or “but” about it. Using a snapshot is not support either but does works only if there is a single site and SQL is installed on the same server as CM07, but I still recommend doing the CM07 backup too. This way you are still supported by MS.

This post will tell you how to get the heartbeat. http://smsug.ca/blogs/garth_jones/archive/2011/02/03/pc-s-last-heartbeat-date-amp-time.aspx

That is a Software Inventory report which has nothing to do with either AI or Hardware Inventory. BTW I always recommend not enabling SW inv. There is just too much overhead and very little gain. You should look at Count of all instances of software registered with Add or Remove Programs instead.

Sorry No. Advert status is based on status messages not inventory data. You could try resending the same advert to those clients but....

@MDMoore313 Is that for the same time frame?? it si unclear from your log snip-it

There are two things. This should fix itself. If this doesn’t fix itself within 2 HW inventory cycles (default 14 days), the only way to fix this is to force a full inventory to occur. Download this tool and force a full inventory http://sourceforge.net/projects/smsclictr/

What is the title of the report you are running?

I don't see anything in that log file that indicated CM12 is forcing the reboot of the WS. Have you confirmed that no SU have been applied to these WS? Have you confirm that the time zone settings are correct? Are the MW setup to use UTC? Are you sure that only one MW applies to these WS? What does the Event Viewer say? Aka are there any other items within it that might lead to what is going on? What about schedule tasks?

The Execmgr.log would be the first place that I would look for a CM12 issue. Do you have an silent Adverts? What do they do? Have you create Maintenance windows for your PCs? This will prevent rebooting outside of those windows.

That is correct. A package with no source will NEVER be deployed to a DP. To this this remove it from the DP and everything will get good.

You can't do this via CM12 but you might be able to do this via GPOs.

Look at the properties of the ARP64 line.. You will find that it say "Join" or "Inner Join", this needs to be changed to an "Outer join".. and by the looks of it a "Left outer join". I would write this for you but I'm sitting in lobby of my car dealer waiting for my car to be fixed. :-)

What you are asking for is not a simple request. However you can quickly determine if a query name exists by creating a query with the following: select * from sms_query where query.name = '<your query name>' BTW watch out for typos and I free hand wrote this query.. but it should work.

If I understand you question correctly, yes you can have more than one report services point within CM12. BTW I just tested this yesterday myself..

The problem is going to be related to you query and how you have the joins setup... You will need to use Left outer joins to solve this issue, you will need to do this on the Joins tab.