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 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 🙂

SCCM 2012 – CM12R2RegistrationRequest

Hi All, while ago, i created the ConfigMgrRegistrationRequest . This tool was written in C# and used the beta/RC version of the CM12 SP1 SDK. Since then, i started to move all my scripts from any language (vbscript, c#, etc) to powershell and today i’m happy to announce the beta version of the CM12R2RegistrationRequest. If you don’t know what this tool is, let me explain: This tool allow you create fake clients in the configuration manager enviornment. but you may be thinking why someone wants that? Easy.. 1- size of your database 2- test reports 3- load Once you run the tool, it will open a file called Import.csv (where you need to change the domain, site code, ip address, etc) and create a new record for each new PC. It will also send a DDR, request policy and send a test hardware inventory. As you may notice, there are…

Unable to Add Windows Server Update Services role

Hi All, recently i was at a customer site to add the SUP role on a WS2012R2 box and when i was trying to add the Windows Server Update Services, it was failing. every time i got the error The request to add or remove features on the specified server failed. The operation cannot be completed, because the server that you specified requires a restart. The first couple of times, i rebooted as i tough that could be something related as i was doing some other changes, but after that i noticed that it was not it. Event viewer, under Setup, was giving me the error: Update UpdateServices of package UpdateServices-CoreService-Package failed to be turned on. Status: 0x80070bc9 And looking at the error, i discovered this: The requested operation failed. A system reboot is required to roll back changes made. i did a bit of research, i discovered that the…