-
Posts
1939 -
Joined
-
Last visited
-
Days Won
92
Everything posted by GarthMJ
-
Are you using Riverbed or something like that? Hash errors can be fairly common on these WAN accelerators.
-
Did you migrate CM07 to the new domain or just your WS? Are there two CM07 sites or just one CM07 site that is connected to two different domains and are the domain within the same forest? In which domain does your CM07 site server exist?
-
Querying AD is better for this. CM12 will not know when a PC was last on the network. At best you can find out when CM12 last "saw" the PC but that is not the same thing.
-
It sound like your IIS is having problem, you might need to re-install it. Or better yet move to the SSRS reporting.
-
I’m not sure what you mean.. If the SU are not deploy then, I not sure what you are looking for, have you tried deploying the SU listed in report?
-
What you are looking for is not a simple 5 minute query. The simplest way to do this is to sort by version number so that you can see the latest version at the top.
-
Generate SCCM Report with below parameters
GarthMJ replied to Jameer's topic in Configuration Manager 2007
The information that you are looking for is not collected by CM07 by default. You will need to collect this data first before you can write the report. -
Currently there is no way to limit reports to a particular collect. You only option would be to create custom reports for these use and do the limiting yourself. This is a lot of manually labour but it can be done.
-
Find what Collections a computer is apart of?
GarthMJ replied to brink668's topic in Configuration Manager 2012
Yes.- 23 replies
-
- SCCM 2012
- collections
-
(and 2 more)
Tagged with:
-
Find what Collections a computer is apart of?
GarthMJ replied to brink668's topic in Configuration Manager 2012
You can run a query to get this info. select C.CollectionID, C.Name, C.Comment from dbo.v_Collection C join dbo.v_FullCollectionMembership FCM on C.CollectionID = FCM.CollectionID Where FCM.Name = 'ES-06'- 23 replies
-
- 1
-
- SCCM 2012
- collections
-
(and 2 more)
Tagged with:
-
Deploy a application for a permanent basis?
GarthMJ replied to shawnyuen's topic in Configuration Manager 2012
Have you looked at using the detection rules used by applications within CM12? Detect that the shortcut is missing and it will re-install the application. -
Keep in mind that even if you don't get the SA password you might still be able to grant yourself SA access but ONLY if you have console access the server/ VM.
-
Check you premission within SQL. It doesn't look like you have full rights to the db.
-
There is no way to do this out of the box. You will need to look at 3rd party software to help manage this.
-
No there is no way to do that. What are you trying to do?
-
can you post the query that you have now?
-
How to move SCCM Database to another SQL Server
GarthMJ replied to farisnt's topic in Configuration Manager 2012
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. -
How to move SCCM Database to another SQL Server
GarthMJ replied to farisnt's topic in Configuration Manager 2012
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. -
Inventory PC installed with SQL Server does not report the version of sql
GarthMJ replied to Fray's question in How do I ?
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"
-
Inventory PC installed with SQL Server does not report the version of sql
GarthMJ replied to Fray's question in How do I ?
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.
-
Backups without the Built in Backup procedure
GarthMJ replied to Ocelaris's topic in Configuration Manager 2012
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!