SQL

Awesome news – Book & Software

Hi All, i have some awesome news to share with you. 1st news, yesterday my new SCCM e-book was finally released. It took some time to write up and test. With 197 pages divided in 33 chapters, you’ll find lots of good info. The book has also over 160 powershell scripts, so you can automate almost (if not all) SCCM tasks you’ll be performing on day to day basic. And on top of that, it is free. To download, access https://goo.gl/CmRTcm, fill up the form and download the PDF. 2nd news, yesterday we also released a new version of our Dashboard software, now called DataExplorer with modules for SCCM, SCSM, Hyper-V, Active Directory and Office365. To download a trial version of the software, access https://goo.gl/O0foHg, fill up the form and download the Setup file.

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…

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…

SCCM Administration Free E-book

Hi All, in the past few months, I have dedicated to update a manual that I have been using on my SCCM courses. This manual is now a free e-book and focus on the step-by-step of the basics administration of an sccm environment, so this is the exercises manual. I still development my own material and delivering many sccm courses based on the material, as you can imagine, the courses I provide the “why” click here and there, so if you’re new to SCCM and want to learn more about it, you will be more than welcome to attend to one of our curses. Check them out at .http://www.rflsystems.co.uk/training/ Anyway, this e-book focus on the basics of the administration. In this e-book you’ll be guided since the creation of the lab (that is based on Windows Server 2012 R2 Hyper-V). And we cover topics like, installing SQL, SCCM, Installing Site…

RFLSystems-New Website and updated tool

Hi All, Today I’m proud to announce that RFL Systems’ new website is finally live and more content will be added soon. This is a great milestone for the company and I only have to say thanks to everyone that helped us until now. With the release of the site, we are also releasing the 1st public beta of our professional version of the dashboard, now renamed to Business Intelligence Dashboards for System Center Configuration Manger (or what we are calling BI Dashboards for SCCM), with the final version to be released in the next few of weeks. The development of the BI Dashboards for SCCM started last year and it is a cutting-edge data visualization platform which helps enterprises to streamline the access, control and management of strategic business information. The BI Dashboards for SCCM makes it possible by displaying the status of key metrics and indicators in one…

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-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 2012 R2 – Who dun it?! What have your admins been doing?

Players, A client of mine started slowly but surely getting more and more of his staff to start using SCCM 2012 R2. I created some custom RBA for his team, but as soon as I left … it seemed that some of the guys got lazy and just started adding people into the administrators group … So some admins had access over stuff in SCCM that they really should be allowed to touch … Long story short … some collections were deleted (by accident) and we needed to understand why and by whom. The guy wasnt in trouble, we just needed to identify who the admin was, so we can train them on how to manage collections correctly. Now there are many ways of doing this … My client wanted the “easiest way possible” to see “who dun it” in SCCM. So, there are actually some inbuilt reports in SCCM that…

SCCM 2012 R2 SQL Query Issues

Players, A client of mine had a issue with a custom SCCM query we created to find malicious software, he wanted to edit it, something went wrong and the console crashed. So we wanted to delete it and start again as we had the query backed up anyway. When we tried to delete it, we got a random error message and it simply wouldn’t move. So we ripped it out of SQL, here’s how we did it. Connect to your SCCM Database (CM_Sitecode), 1. Expand tables2. then right click “dbo.queries” and edit the to 200 rows3. Selected “Custom Query NAME”  then right click and then delete it. You’re also able to edit the query should you need to for SQL it self. Enjoy 🙂

SQL Server Service Broker and Dynamic Ports (SCCM 2012 R2)

I got a mail from a friend of mine that was having some SCCM and SQL difficulties, after a short explanation, I was able to fix it, the problem was the SQL broker service. The SQL Server Service Broker (SSB) is used to replicate data between database sites. You will need to specify a port that needs to be used by SCCM. So remove the dynamic ports (leave then blank and not at “0”) and specify the port at 1433 (only if its changed). You can view what port the SSB is using by running the following query on the SCCM SQL server. SELECT name, protocol_desc, port, state_desc FROM sys.tcp_endpoints WHERE type_desc = ‘SERVICE_BROKER’ Enjoy.