Your company's ad could live here and reach over 50,000 people a month!

Month: May 2016

Last Day to Request May’s Free SSRS Report

Don’t forget to email Info AT Enhansoft for your copy of this month’s free SSRS report, List of PCs by Share Type! The List of PCs by Share Type report provides the PC name, user name, share name, share path, and share caption for a particular share type and system role. Knowing this information is helpful in tracking down rogue shares that may not be properly configured or shouldn’t exist in the first place. This report is only available in May.

Last Reminder to Vote for Enhansoft’s Next Free SQL Server Reporting Services (SSRS) Report for the Month of June

The report choices in May’s poll are Count of SQL 2008 Editions OR Computer Network Logon Details. The network logon report is still ahead with 61% of the vote. VOTE HERE! Later this week we’ll announce the winning report which becomes June’s free SSRS report. a) The Count of SQL 2008 Editions report will provide you with a count of all SQL 2008 editions within your environment. In the full-feature set this report will drill through to List of PCs by SQL 2008 Edition which in turn drills through to Computer SQL Details. b) You can have multiple network logon types, so the Computer Network Logon Details report will show which network logon types are active for a specific PC, i.e. Microsoft Windows Network, Novell, etc. In the full-feature set this report is the final drill through report fr...

Configuration Manager Reporting Unleashed–Win an eBook!

We are giving away five copies of Garth Jones’ new eBook, System Center Configuration Manager Reporting Unleashed. What do you have to do? It’s simple. 1. There will be one winner for subscribers to Enhansoft’s newsletter. 2. There will be one winner for our Twitter followers. 3. There will be one winner for our LinkedIn followers. 4. There will be one winner for our Facebook page likes. 5. There will be one winner for our Google+ followers Increase your odds of winning by doing all 5! You have until June 14, 2016 @4:30 pm EST to win! But wait, there’s a bonus set of eBooks to give-away! Share, re-tweet, or re-post this notice to any of the four social media sites and your post will be automatically entered into a draw. Four random winners will be selected from all possible entries! Legal ...

Customize SSRS 2016 in Under 30 Seconds!

By Garth Jones As I reviewed my blog posts about SQL Server Reporting Services (SSRS) 2016’s custom brand package feature (New SSRS 2016 Custom Brand Package Feature, How Do You Configure and Import the SSRS Brand Package, and Matching SSRS Brand Colors with SSRS Site Items) I realized that I didn’t touch on the simplest way to customize your SSRS site. Adding your organization’s name! Yes, I know that I could go into a long-winded speech about how easy it is to add a company name, but instead I put together this short how-to video. Keep in mind that any changes you make will apply to all users on the site. Customize SSRS 2016 in Under 30 Seconds Video In the video you will see that in under thirty seconds I was able to brand my SSRS site with Enhansoft Inc. This takes your site to the nex...

Want to Edit Reports Using ConfigMgr 2012 Report Editor?

By Garth Jones A good friend of mine asked me the other day if I had a RBA security role for Report Editor. I’m sure that I used one before, but for whatever reason I couldn’t find it, so I created a new one! Here’s the download. In a nutshell this security role is an exact duplicate of the Report Reader ConfigMgr security role I created not too long ago, but for Report Editor. The Edit Report security option is enabled for each instance. This will allow you to edit and/or download existing reports from ConfigMgr. However, what this does NOT do is grant your users access to the ConfigMgr database. You will still need to give them access to SQL, so I recommend granting your users db_datareader rights to the ConfigMgr database. This will allow them access to query the database, BUT they will...

Troubleshooting Disk Space Reports

By Garth Jones The other day I wanted to know my servers’ free disk space availability. However, when I ran the built-in ConfigMgr report, Computers with low free disk space (less than specified % free), no results appeared. Then I remembered that starting with ConfigMgr 2012, the free disk space attribute is not enabled by default, so you need to enable it! Thankfully, it’s a simple process. All of the screenshots below are from my ConfigMgr Current Branch lab.   Open the ConfigMgr console, select the Administration work area, select Client Settings, right-click on Default Client Settings and then select Properties. Select the Hardware Inventory node and then click on the Set Classes… button. Locate the Logical Disk class and then select the Free Space (MB) attribute. Click the OK button ...

Using PowerShell to Automate Downloads of MMS 2016 Sessions

I’m just returning from a wonderful week at the Mall of America attending the 3rd annual Midwest Management Summit. MMSMOA was once again a successful endeavor and those involved in pulling it off should be highly commended. For those that attended and would like to grab all the session files at once, Andrew Johnson has developed a PowerShell script that download everything… PowerShell Script to Download MMS 2016 Session Files Next up for me is IT/Dev Connections 2016 (ITDC). Much like MMSMOA, but instead of covering a specific product, ITDC reaches the entire Microsoft stack of products – from Office 365 to System Center to Visual Studio. Looking for an awesome, no-nonsense technical conference for IT Pros, Devs, and Devops? Check out IT/Dev Connections!

Reminder to Help Choose Enhansoft’s Next Free SQL Server Reporting Services (SSRS) Report for the Month of June

The report choices in May’s poll are Count of SQL 2008 Editions OR Computer Network Logon Details. So far the network logon report has 60% of the vote. VOTE HERE! a) The Count of SQL 2008 Editions report will provide you with a count of all SQL 2008 editions within your environment. In the full-feature set this report will drill through to List of PCs by SQL 2008 Edition which in turn drills through to Computer SQL Details. b) You can have multiple network logon types, so the Computer Network Logon Details report will show which network logon types are active for a specific PC, i.e. Microsoft Windows Network, Novell, etc. In the full-feature set this report is the final drill through report from List of PCs by Network Logon Type. All of our reports have the Role-Based Administration (RBA) ...

Matching SSRS Brand Colors with SSRS Site Items

By Garth Jones In my last blog post I showed you how to edit the three files needed for the SSRS brand package. In this post I will show you how each attribute and its color code was edited in order for me to create the first Enhansoft SSRS brand page. There are 5 main color sections in the colors.json file that should concern you: · Primary Section – button and hover colors. · Secondary Section – title bar, search bar, left-hand menu colors, as well as text colors for those items. · Neutral Primary – home background and report area background colors. · Neutral Secondary – text box background, folder options background and settings menu colors. · Neutral Tertiary – site setting background color. I marked off nine different elements in the screenshot within the SSRS Site Settings page below...

How Do You Configure and Import the SSRS Brand Package?

By Garth Jones Are you like me? Do you want your SSRS site to have your company’s look and feel? Then I’ve got good news for you! Starting with SQL Server 2016 Release Candidate 1 (RC1), you can add your company’s name or logo, and colors to SQL Server Reporting Services (SSRS). As I write this there isn’t a lot of details about how to exactly do this, but the best source of information is from the SQL Server Reporting Services Team Blog. They have a post entitled, How to create a custom brand package for Reporting Services with SQL Server 2016 which is a great starting point. I know that a lot of System Center Configuration Manager (ConfigMgr) administrators will not be following the SSRS Team’s blog, so I will provide you with the steps on how to create your own custom SSRS site. Getting...

Windows 10 Images in SCCM: Size Matters

If you are migrating your company’s computers to Windows 10 using Microsoft System Center Configuration Manager (SCCM, aka ConfigMgr), you make a lot of little decisions that can have massive down-the-line impact. A key decision to get right in operating system deployment (OSD) is image size. Specifically, whether to create Thick or Thin images. A Thin image consists of the Windows 10 OS and approved updates, and very little else. A Thick image may include the OS plus approved updates, plus software like applications and other customizations needed to make the machine more directly useful for business tasks. The Trade-off Admins Must Make So, what’s the trade off? It’s an age-old problem that existed long before computers: time versus functionality. A Thin image is much faster to deploy in...

New SSRS 2016 Custom Brand Package Feature

By Garth Jones SQL Server Reporting Services 2016 (SSRS) has a new exciting feature that will allow you to customize your SSRS site with your company’s logo or name, and color scheme. I couldn’t wait to install SSRS 2016 Release Candidate 2 (RC2) to check out this feature with System Center Configuration Manager (ConfigMgr)! Below is the default Site Settings SSRS page with Microsoft’s logo and color scheme. I took some time trying out this new feature with Enhansoft’s logo and color scheme and you can see the results in the screenshot below. See how the custom brand package changes the look and feel of your SSRS site? Given that this was my first attempt at creating complimentary colors for Enhansoft, I think it turned out great! I’ll be honest with you, it will take a bit of work to upda...