Search the Community
Showing results for tags 'Reporting'.
-
Does anyone know of a way to create a report that shows a list of Windows 10 Pro devices that are configured with BitLocker from Intune? Since they are using Pro Edition, Endpoint Protection Policies don't work so I am using the default Windows Device Restriction Policy that includes device encryption in the Azure AD Join process. The only type of reporting option I found was using Intune Data Warehouse in conjunction with PowerBI. So far, I set it to show "osCaption", "deviceName", and "encryptionState". The problem is that the data that comes out of the "encryptionState" is very confus
-
Is it at all possible to search the version field using something that would show me "Not Equal to" or "Less than or Equal to"? Thanks! -
I'm trying to create a custom report which will give me an idea of how many local profiles are each machine. So far, I've been able to come up with a report which will tell me this but it lists the each instance of a profile with the workstation it's on. So, for example, if Bob1 and Bob2 have a profile on PC1 with will list this as two entries in the PC column. What I want to do is end up with a reports that will count the profiles and list those with the most in either descending order or over a certain amount (think I know how this is done). Here's what I have already: SELECT
-
My reports are not showing up under my console. (Monitoring, Reporting, Reports). I've added Administrator User for the Reporting. And created a custom role for this purpose. When I go to reports in the console, it shows as: http://sccm2016/Reports_SCCMTEST16, and when it attempts to open, it gives this error: The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. (rsReportServerDisabled) Get Online Help Keyset does not exist (Except -
Here is the scenario: This ConfigMgr environment has a complex configuration with 2 different SQL servers in play. ▪ Server 1: ConfigMgr Primary Site server ▪ Server 2: server running SQL Server Database Engine role and configured as the ConfigMgr Site Database server ▪ Server 3: server running SQL Server Reporting Services role pointing to the SCCM DB created on Server 2 when attempting to install the Reporting Services point, the following error was encountered: Unable to locate any configured SRS instances on the server. Verify
-
Hi, First post, relatively new to SCCM but I have a question. We upgrading our servers to 2012 r2 and 2016 but don't want to use SCCM to manage updates for them. They are currently set to download and install updates via Windows update but I am unsure whether this will mean that SCCM will be unable to report on the status of installed updates for those servers. Is it only able to identify the status of updates deployed by itself? Thanks, Simon -
Hello everybody! I work for a K-12 school district and we just deployed System Center about a year and a half ago. I have a background in Novell, however, we converted to Microsoft at the same time we stood up System Center. All this done in approximately six months with no project planning to speak of! So, I (for one) am still playing catch up. My role is now Service Manager Administrator, mostly. Someone else installed it, and now I'm running it. At least, I like to think I am! Anyhow, so far so good. At this point we have only rolled out Service Requests. Next month we will pilot Incident R
-
All, I am trying to report on what machines might have a vulnerable chrome extension for Webex. These are stored in the user's profile in app data. I have created a config item and baseline trying %userprofile% but am having no luck. Any direction would be great if you know how I might gather this information for different users on different machines in my environment. Thanks! Rob -
Hello all, I was wondering if anyone knew a way to automatically sync the SCEP definition to SCCM without needing to reboot. For instance, the SCCM console shows me that my server has the endpoint definition of 1.215.422.0 but after checking locally I have 1.215.565.0. This inaccurate result is throwing off my reports. If I reboot the server in question then SCCM shows the correct version. Is there another way to get this to sync without a reboot?
-
I am happy to announce that you can now pre-order my new book entitled, System Center Configuration Manager Reporting Unleashed. What I love about this book is that there are so many demonstrations. These demonstrations help reinforce the topics discussed within the chapters. Reporting Unleashed will show you from start to finish how to create a ConfigMgr report. Best practices for report design and creating report templates are noted, and all of the listings, code snippets and RDLs can be found within the online content. There is even a section on how to create Role-Based Admin
-
When running a report today, I noticed that it did not pull in Windows 10 as an Inventoried Product. I went an searched through the Inventoried Software, but it was not listed. I then searched to make sure that it was inventoried within Resource Exploroer, and Windows 10 is listed in there. Why is it not Displaying withing the Inventoried Software? Is there a Hardware Inventory Class I'm missing to properly display it? -
Hello everyone! I've got a task to create a query to show the computers which has more then one installation of Java on it (sometimes Java doesn't updates correctly). So I quickly created a query: select distinct SMS_R_System.Name, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS.Version from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Java % Update %" order by SMS_R_System.Name And this query shows me all the
-
We have ADRs set up to find updates monthly then create deployments (not enabled) for our servers. We would like a nice report of what updates were found by the ADRs emailed to Web and Dev teams so they can review them. How can this be done? I haven't found any built-in reports that seem to do the job. Figured someone here has probably needed the same thing. Many thanks! -
Greetings! Recently I was tasked with working on our MS True-up. I have imported our information from the MVLS and I am even able to pull the report. My problem is, the report is not very clear. I am supposed to give totals but here is the columns of information that I have to select from: Family Name | Version | Effective Licenses | Unresolved Licenses | Inventory Count | Initial Diff | Diff. after applying Downgrade Right I need to provide the amount of MS Office Pro Plus installed. Any help or direction would be greatly appreciated JL
-
Hi. CM2012 SP1. Trying to generate reports of OSD task sequence usage, it appears that the deployment names are static, and don't actually reflect the current name of the TS. E.g. if I create and deploy a TS named "TEST - Win7 64-bit" and then after testing is done, change the name to "Windows 7 64-bit, Off2013, HR apps," the reports don't see this name change. So running the "History of a TS deployment on a computer" or "Deployment status of all task sequence deployments" and the reports linked from it, they all reference the old names of the task sequences, instead of the current -
Hi all, I am having some issue's with WSUS and SCCM 2012 and I have only been using it a few months so I am very unfamiliar with the logs / log locations. We have Sys Center 2012 R2 installed. Each application (SCSM, DPM, etc.) has its own dedicated server. We have an upstream server for WSUS that downloads all updates (Server 2008 R2). SCCM is pointed to the WSUS Server in Site configuration -> Software Update Point -> Sync Settings -> Sync from upstream data source GPO Is set up for each group (Download, Download & Install, Download & Notify, etc.) and RSOP sh
-
Hello, I am new to SCCM, and have a 2007 R2 deployment I currently manage. We are migrating to 2012 R2 later this year, but in the meantime I have a request for an inventory report from our server team I'm trying to pull together. I've never worked with SSRS before, and have been struggling to find the right query. I'm hopful someone here could help. I'm trying to get the information below for all of our server systems: NetBios Name Domain Name OS Version/SP level Number of Processorss Number of Cores (preferrably just physical, not hyperthreaded) Physical or Virtual Physical
-
Hi, From Past few days i am facing a problem in Reporting and google a lot with no success. On My Primary server SCCM 2007:- Issue is :- In Reporting> Management 2- Updates in a Deployment. When i try to run this report and after selecting the windows 7 collection to see April Month Software Updates deployment report,, each and every column shows " 0 " but under "UnKnown" column.it shows 180 count in each row. But... When i try to run the same report on My SCCM 2007 Central Server its shows all the report correctly as per the requirement with some figures as well under Instal
-
Hello, I have inherited a SCCM environment and I need to configure reporting services for an asset manager internally. It looks like the current install is a bit broken as when we browse the website internally we get the attached site. reporting We can run reports from the SCCM console ok however. Our SCCM environment is running on two servers 1 Server Running as the Primary SCCM site 1 Server running SQL as a site system server Screen shots of roles installed to each server. Could it be that we are missing a cretin component from our SQL server to have the reportin
-
Hi, I currently have SCCM 2012 in my production environment. I have noticed all my client are downloading and installing updates which i deployed on my windows 7 collection, when i check my report States 3 – States for a deployment and computer to check if my Windows 7 computer are up to date, some of the client computers does not appear in the mentioned report. Can anyone help me out. Thanking you. Regards, Yassein. -
I am stuck and I need a bit of assistance as to where to go next. I have a CM12 hierarchy system setup with a CA and a PSS (and a few DP site servers). I am trying to get software metering reports to work and cannot seem to get them to populate with data. It appears that data is being parsed into the SQL database on the PSS because I can query the associated tables in SQL Management Studio and see that data in views such as v_GA_SoftwareUsageData but whenever I run any of the web reports I cannot select dates or software items. I have forced summarization by running runmeteredsumm.exe on the P
-
Good morning, I have printers set for inventory on my SCCM 2012 environment. I need to run a query on all USB/LPT connected printers in the district. Can someone please help me with a query/report or something that I can run that will give me a list of all printer models that have been collected from all my clients? This will help me in collecting drivers while we go forward with our district-wide windows 7 migrations. Many thanks! -
Hi All Im after a software report in SCCM 2012 that will give me everything that the 'Software 02E - Installed Software on a specific computer' gives me but i want to exclude certain Product Family/Categorys? Anyone know if this is possible? other than exporting to Excel and manipulating Many Thanks in Advance Regards Mark
-
I am trying to set up reporting on SCCM 2012 Sp1, mostly following this guide: http://www.windows-noob.com/forums/index.php?/topic/4550-using-sccm-2012-rc-in-a-lab-part-11-adding-the-reporting-services-point-role/. I had originally set up my CM Database on the same server as SCOM. --------------------------- Configuration Manager --------------------------- At least one report category must exist before a report can be created. Create a report folder, then try again. --------------------------- OK --------------------------- I saw this thread: http://social.technet.microsoft.com/Fo -
In our last post we installed SCVMM, now we need to install Reporting. Now that we have SCVMM installed, we want to be able to report on the utilization and capacity of our hosts and VMs. The only requirement for SCVMM reporting, isn’t SCVMM at all, but rather System Center Operations Manager (SCOM)! Huh? Why do you need to install a different System Center product just to have reporting for SCVMM. Well, according to Microsoft: “We did this for one big reason; to leverage the rich capabilities of object pickers available in the OpsMgr reporting infrastructure.” That, and “you ne
