Everything posted by GarthMJ
- help on reports sccm2012
- Creating Custom Queries in SCCM 2012 SP1
- Publish SCCM reporting on SharePoint
- help on reports sccm2012
-
Report advice
Have you enabled all of the AI classes to be inventoried?
-
Update Last Boot Up Time?
Hardware inventory will be what updated this info. Set your HW inv to daily.
- Office 365 query
-
Query/Report that gives list of ALL local printers at site
Enable the win32_printer class within hardware inventory to get local printer.
-
SCCM 2012 Query Help
This report query will help you out. http://smsug.ca/blogs/garth_jones/archive/2012/07/02/how-to-find-an-application-installed-in-the-last-7-days.aspx
-
Find what Collections a computer is apart of?
Replace 'ES-06' with @PC This will create a prompt for the report. If you want to make it fancy you can then add a drop down or browse list for the PC name. The easiest way to convert your CM07 to CM12 report is to make sure that you have already converted them from ASP to SSRS then you can upload the same converted reports to CM12. Other than that, I your recommend rebuilding them and filtering out all the old junky reports.
- Installed Software on a computer (with a twist)
-
Wrong Collation on a used SQL Server
It is not possible to run CM12 with any other collation and you want you temp db to be the same collation too. As an aside I NEVER recommend that SQL be remote from CM12.
-
SCCM and SCSM on thesame server?
I generally agree with AdinE but if this is seriously only for 150 users/devices then I would think that you can do it one 1 box, assuming SCSM will allow you to install everything on 1 box.
-
Reporting Services Point with SQL Cluster
Create a report, I think that I missed that tidbit, did you copy the SQL certificate to you local PC? And just to close off the other bit, can you run report from your RPs?
-
Reporting Services Point with SQL Cluster
Where did you install the RP? Are you trying to access the site via the cluster or the one of the node of the cluster?
-
Reporting Services Point with SQL Cluster
There is no best practice either way, there is few note about performance on site with 100 000 device or more. However, from a management standpoint you will have far fewer support issues with SQL be local than with it being remote. Heck I add 15 days to any project where SQL is remote due to the complexity it add and the inevitable problem that will crop up over time.
-
Reporting Services Point with SQL Cluster
SSRS is not supported to be installed on a cluster. You can install SSRs on one or both node but each will be separate install of SSRS. In order to use CM12 RP you would need to install the RP on each node and access then via the node address not the cluster address. As an aside, I never recommend splitting SQL from the primary server.
-
SCCM 2012 in education - preventing any restarts during school hours?
What is causing the reboot messages? Are you sure they are CM12 Messages and not something like Windows Update?
-
Microsoft Updates must be download automatically to newly installed machine in my Domain.
So how are you deploying you server?
-
Microsoft Updates must be download automatically to newly installed machine in my Domain.
You can do this with WSUS or CM07/CM12. Are you using CM07 orCM12?
-
Configuration Manager SSRS Report Survey
We are looking for your help! Help us about by take 2 minutes to complete this survey about SCCM reports. It will help us decide on what new reports to add to Enhance Web Reporting (EWR) and what new reports we will be giving away in the future. http://fluidsurveys.com/surveys/info-HZv/configmgr-ssrs-report-survey-sept-2013/
- Server machine not restarting after Install all the updates
- Server machine not restarting after Install all the updates
-
SCCM collection query script
Have you talked to the team at Flexera to see how they suggest you handle this issue? They are the best people to talk to about this.
-
Can't set up reporting in CM2012, "At least one report category must exist before a report can be created."
This should be an non issue as you are using the CM12 server for SSRS, just create the reporting role on the server and then use the real CM12 db for the source.
