reports

TucanData DataExplorer

The TucanData DataExplorer was initially developed by RFL Systems (company acquired by TucanData in September 2016 – more info about at http://thedesktopteam.com/raphael/tucandata-acquires-rfl-systems/). The solution provides extensions to enterprise applications, enhancing reports and data visualisation capabilities. TucanData’s DataExplorer is a cutting-edge data visualisation platform which helps enterprises to consume and distribute strategic business information. The solution was created to help System Center Configuration Manager (SCCM) administrators to analyse and monitor SCCM data as well as provide an easy way to allow a non-technical person to understand the SCCM Data. The solution has expanded since its conception and today it also has Active Directory, Office 365, System Center Service Manager (SCSM) and Hyper-V modules. It provides the following benefits: – Straightforward and easy to use. Visualisation of what you want is just a drag and drop click away; – Ready to use. There is no need to spend time creating queries and…

SCCM-SQL Server via PowerShell

Hi All, the 3rdpost of this series of SCCM via PowerShell, we’ll be looking at the SQL Server Installation & Configuration for SCCM… 1st, we need to create the firewall rules for SQL. I’m assuming the installation will be done using default instance, so the default port will be TCP 1433 and assuming the SSB Port (for SCCM Data replication if you have a hierarchy) will be 4022 (default).  

  2nd- Install the SQL Server. For this, you’ll need to have access to the SQL Server 2016 RTM source files. Copy the content of the DVD to c:\SQLSource. I’m also assuming the installation will happen on the C:\SQLServer and C:\SQLServer (x86) for the shared x86 files. I’m using the SYSTEM account for the services and will add the CLASSROOM\SCCM Admins as sysadmin (change as required)  

  3rd- Install SQL Management Studio. I’ve downloaded the file to…

Data Explorer v1.1 release

Hi All, Today, we are proud to announce: BI Dashboard has been renamed to Data Explorer Data Explorer has been extended and now has modules for not only SCCM, but also for Active Directory and Office 365 A new version (v1.1) is now available Since the release of the v1.0, our development team have been busy and with release of v1.1, we have fixed 39 issues and added 55 new functionalities. A full list of the changes can be found here. And we are also working hard to keep our documentation website always up to date. We will be updating our online and offline documentation often, so keep your eyes open on https://docs.tucandata.com/. Try it now! Make sure you download the software here and enjoy a 45 days trial. Hope you will enjoy and feel free to ask questions and provide feedback.

SCCM-Reporting

Hi all, Over the last couple of weeks, I’ve been reviewing the latest book from a friend and fellow MVP Garth Jones called System Center Configuration Manager Reporting Unleashed. I have to say that I was impressed how good the book was written and cover most (if not all) aspects of what you need to know about reporting in SCCM. Of course, there are load of things that only the experience will teach you but this book is a good start. Over the years working with many companies that uses SCCM, I could “classify” the SCCM admin in 4 different categories: 1-Novice – someone that is starting with SCCM, he/she normally do not have any experience with SCCM nor with SQL and Reporting 2-Junior – someone that has a good knowledge of the SCCM when using the console, however, cannot do anything else. he/she may have a some knowledge of…

ConfigMgr HealthCheck toolkit – Beta 04

Hi All, after long, long time, we are happy to announce that the HealthCheck toolkit is once again available for download and we released a new version, beta 04 with some small fixes… What is the System Center Configuration Manager HealthCheck Toolkit? The System Center Configuration Manager HealthCheck Toolkit (CMHealthCheck) has been created to check for problem and/or misconfiguration in the SCCM environment and, when possible, will provide you with some solutions for problems. You can download it for free from: http://www.rflsystems.co.uk/software/healthcheck-toolkit/ how to use it: 1- CollectData.ps1 (This script will collect information from a CM12/R2 Infrastructure). Open the powershell (64 bits) and run with an account that has admin rights on the cm boxes as it will connect remotely to registry, wmi, etc. CollectData.ps1 -smsprovider servername (ie. CollectData.ps1 -smsprovider srv0003) Once it collect data, it will create a CollectData.log under _Logs and will create a Date\servername folder (ie. 2013-12-05\srv0003)…

RFL Systems’ BI Dashboard v1.0 release

Hi All, today we are proud to be releasing the v1.0 of the RFL Systems’BI Dashboard, a cutting-edge SCCM-focused platform that streamlines the access, control and management of strategic data. Compliance for software updates, application deployment, client health and anti-malware monitoring are some of the key indicators that you can manage through the BI Dashboard. We take care of simplifying your SCCM data analysis whilst focus on making effective and well-grounded decisions CustomisableYou can tailor how you want to access your data anytime, anywhere. Crystal-clearOur technology makes it easier to convert data into business value. SecureYour data security is a priority through our on-premises software. Easy-to-useStraightforward and simple software and interface. Trial it now! Make sure you download the software here and enjoy a 45 days trial. Hope you will enjoy and feel free to ask questions and provide feedback.

SCCM-Running RBAC queries on SQL Mgmt

Hi All, SCCM 2012 R2 introduced the RBAC to reports, what I mean by that is that now, users will be only able to see what they have rights to see. This is done by the introduction of the @UserID parameter to the reports. This parameter is hidden, so you don’t even know that it is there. however, if you try to run a report query on a SQL Management Studio, it will not like. As workaround, you can change the @UserID for ‘disabled’ and it will not validate the security. More info at http://blogs.technet.com/b/configmgrdogs/archive/2014/07/14/creating-custom-rbac-enabled-reports-in-configmgr-2012-r2.aspx as you can imagine, it is really good, you can get any report query and change the @UserID for ‘disabled’ and test the query, or do the other way around, however, this is not good if you want really know what is returning is what it should return, is it? So, imagine an example: Query1:…

SCCM-Software Update Compliance taking long time

Hi All, have you ever wonder why the Software Update Compliance takes long time to report the correct date? often that I get this question from a customer that wants to know what the status just after a software update deployment, but when I mean just after, I mean just few minutes. there are lots of things that could cause the status not being showing correctly, like network, etc. that is outside ConfigMgr, but in this post, lets talk about the main one, state messages. When using SCCM 2012/2012 R2, the default detailed level setting when deployment a software update group is to report only success and errors messages. this is quite ok for most environments where you go to the deployment node and check things from there, but you’ll not get the compliance for each update. there are 3 options: all messages, only errors messages and the default one…

SCCM-Windows Update 6.2.x on Windows 10?

Hi All, I have been reviewing a report I did for a customer where all Windows 10 machines were reporting Windows Update Agent 6.2.x. what caused my customer to send few people on few windows 10 machines and try to troubleshoot windows update issues where it did not exist. of course, after couple of hours/day, they realise this was a data issue instead of their environment issue. When I started to review, I looked at my lab and I had the same. Executing a query on fn_rbac_UpdateScanStatus, I saw all my windows 10 machines also reporting Windows Update Agent 6.2.x So something was wrong. but why? 1st step was to check if the files on the client where the correct version. if you want to know where I discovered which file to look, click here. As you can see, the file was with the windows 10 version…so I checked Powershell…

SCCM-Compliance Setting Script error 0x87d00321

Hi All, When working with Compliance Settings, I normally end up using scripts and often, I get the error 0x87d00321. If you use CMTrace, you’ll see that the error is: The script execution has timed out. Source: System Center Configuration Manager —– Now, we need to understand how it works and how to change. The script timeout information is saved under the class SMS_SCI_ClientComp, Component Name Configuration Management Agent on a lazy property called ScriptExecutionTimeout. The default values is 60, it means that the script will be timed out after 60 seconds of execution. The value, can be seen when using the following powershell script  

  Now the trick part, how to change? As you can imagine, not that trick if you have PowerShell. The script below changes the default 60 seconds to 600 seconds,  

  if you want this behaviour to be changed or have…