Search the Community
Showing results for tags 'Reporting'.
-
My organization is currently undergoing an SCCM 2007 to SCCM 2012 migration and I am one of the primary stakeholders since I am the SCCM Administrator in my region and I have been tasked along with another regional SCCM Administrator to set up and configure customized SCCM 2012 Reporting for the entire enterprise and spans 5 states and over 50,000 users. I would greatly appreciate it if I can get some feedback from anyone that can offer insigts on how to go about customizing the SCCM 2012 Reporting feature that includes, but is not limited to: How to customize the SCCM 2012 Web Reports Site and use a corporate logo (I did find something from Kent Agerlund here, but wanted to know if anymore info is out there covering this as well). How to develop a naming convention standard for SQL Reports for an organization Any helpful SCCM 2012 Reporting techniques that can make SCCM 2012 Administration life easier and more convenient. Thanks everyone
-
How to move SCCM Database to another SQL Server
farisnt posted a topic in Configuration Manager 2012
Good Day I have Server1 that is hosting: SCCM 2012 SQL 2008 WSUS Reporting DP .... now I got my new SQL Server and looking for : How can I move the SQL database to the new location (Do I also need to move the reporting DB ) ? Is Moving the database named as (CM_"SiteID") will be enough and dose it include all the config like WSUS Database ...etc Incase the reporting service is not installed on the new SQL Server, will the SCCM reports work ??? Thanks alot -
I have been following the advice to create custom forms as deatiled in: www.windows-noob.com/forums/index.php?/topic/1381-computer-model-and-name-report/ Everything works (Fail 1) up to the RUN (Fail 2) then this error occurs (Fail 3) If the report was sucessfully run earlier why would it fail later? More to the point how can I fix it? Note: All the built in reports work correctly O/S 2012 std SCCM 2012 SP1 SQL 2008 R2 SP2 SELECT A.Name0, B.SerialNumber0, A.Manufacturer0, A.Model0, C.Name0 AS 'Processor', D.TotalPhysicalMemory0 AS 'Memory (KBytes)', E.Size0 AS 'Disk Size (MBytes)', F.MACAddress0, F.IPAddress0, G.AD_Site_Name0 AS 'AD Site', A.UserName0 AS 'Last user logged in', H.Caption0 AS 'Operating System', H.CSDVersion0 AS 'Service Pack', G.Creation_Date0 AS 'Creationdate in SMS', I.LastHWScan FROM v_GS_COMPUTER_SYSTEM A, v_GS_PC_BIOS B, v_GS_PROCESSOR C, v_GS_X86_PC_MEMORY D, v_GS_DISK E, v_GS_NETWORK_ADAPTER_CONFIGUR F, v_R_System G, v_GS_OPERATING_SYSTEM H, v_GS_WORKSTATION_STATUS I WHERE A.ResourceID = B.ResourceID AND A.ResourceID = C.ResourceID AND A.ResourceID = D.ResourceID AND A.ResourceID = E.ResourceID AND A.ResourceID = F.ResourceID AND A.ResourceID = G.ResourceID AND A.ResourceID = H.ResourceID AND A.ResourceID = I.ResourceID AND F.IPAddress0 is not NULL AND F.IPAddress0 not like '0.0.0.0' GROUP BY A.Name0, B.SerialNumber0, A.Manufacturer0, A.Model0, C.Name0, D.TotalPhysicalMemory0, E.Size0, F.MACAddress0, F.IPAddress0, G.AD_Site_Name0, A.UserName0, H.Caption0, H.CSDVersion0, G.Creation_Date0, I.LastHWScan
-
Help with reporting in 2007, not sure which report I want and 500 error
caseyj3350 posted a question in Reports
Hello - I'm new to SCCM, and trying to run a report for management to see which systems need upgraded. I tried to run the report "Search for Computers" and put in the collection "Workstation and desktops", and comes back with a 500 internal server error. It works fine with other reports, but this one will be about 17000 computers. Just need computer type and computer name.. Thanks!!! -
i need to give a read and view permission for users. but when thy try to open a report it required a administrator account. who can help me and solve this problem.
-
I keep getting the following error when I try to edit SCCM reports. I downloaded and installed reportbuilder 3.0 on my deployment server and my workstation. I changed the registry to point to 3.0, restarted server, and ran as admin. Regkey that changed: “HKLM\Software\Wow6432Node\Microsoft\ConfigMgr10\AdminUI\Reporting\ReportBuilderApplicationManifestName” I even reinstalled as the Local Admin account. Same error. Anyone have any ideas on what else I may need to do?