How to list SSRS Report permissions

  Have you ever needed to know which groups or users have access to your reports? Use the following query to get a comprehensive list of who has access to what. USE ReportServer GO select u.UserName, r.RoleName, r.Description, c.Path, c.Name from dbo.PolicyUserRole pur inner join dbo.Users u on pur.UserID = u.UserID inner join dbo.Roles r […]

Read More»

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…

Read the complete blog: http://thedesktopteam.com/blog/heinrich/sccm-2012-r2-who-dun-it-what-have-your-admins-been-doing/

Read More»

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

Read the complete blog: http://thedesktopteam.com/blog/heinrich/sccm-2012-r2-sql-query-issues/

Read More»

ConfigMgr 2012: SQL Maintenance Plans and Index Optimization Recommendations

Posted in CM2012ConfigMgrSCCMSQL

Recently caught some emails going around about recommended backup and maintenance plans as it relates to ConfigMgr. Also plenty of discussions around whether or not addition index optimization is required beyond the built-in Rebuild Indexes task that can be configured as part of the built-in Site Maintenance task.  As far as what I recommend and […]

Read More»

SQL Server 2012 SP2 released

  Download here: http://www.microsoft.com/en-us/download/details.aspx?id=43340  List of bugs that are fixed: http://support.microsoft.com/kb/2958429Filed under: SQL, SQL Server, SQL Server 2012

Read More»

Where to Find User Name Data in Configuration Manager, Part 2

By Garth Jones In my last blog post, I talked about how there are three places to find user name details and how they are inventoried. In this blog post I will talk about how best to leverage each of them. Here’s a quick refresher of where to find the user name data by using the following three queries: v_GS_COMPUTER_SYSTEM...

Read More»

How to – ConfigMgr collection updates

This is a topic I haven’t seen much covered around but is quite important, especially if you’re managing an environment with a lot of clients, regular changes and a lot of collections. What is a ConfigMgr collection? According to Technet (http://technet.microsoft.com/en-us/library/gg682169.aspx): Collections in System Center 2012 Configuration Manager provide a method of managing groups of computers, mobile devices, users, and other resources in your organization. So they are nothing more than groups of objects in your environment. How you group them is not mentioned yet or for what reason. Collections can be used to deploy Software, Operating Systems, Task Sequences or settings to these managed groups. Basics covered, we all … Continue reading

Read More»

Get the Most Accurate and Up-to-Date Data Using the v_R_System_Valid SQL Query in Configuration Manager 2012

By Garth Jones When you delete a PC from the System Center 2012 Configuration Manager (CM12) console it is NOT deleted from the database at the same time. Yes you read that right! The CM12 console does NOT delete a PC from the database right away. Depending on how you write your queries, this may affect your results and you...

Read More»

Count of PCs by OU v2

 

For more details please see: http://social.technet.microsoft.com/Forums/systemcenter/en-US/aea60e7b-a88b-48d8-8cc3-8675097abe62/trying-to-do-a-report-of-sup-failures-by-ou?forum=configmgrinventory

 

SELECT
    OU.ou,
    COUNT(*) AS 'COUNT'
FROM 
    dbo.v_R_System SYS 
    join (
            select 
                SOU.ResourceID, 
                Max(SOU.System_OU_Name0) as 'ou' 
            from 
                dbo.v_RA_System_SystemOUName SOU
            Group by 
                    SOU.ResourceID) OU on SYS.ResourceID = OU.ResourceID

/*WHERE SYS.Netbios_Name0 IN ( 'PHO-PVR63186',
'WCO-PVP11579',
'PAL-PVI82336',
'LOM-PVI46044',
'LOM-PVI49102',
'LOM-PVR46148',
'PUG-PVI92643',
'RED-PVI54875',
'REN-PVR27553',
'WLA-PVR125834')*/
Group by 
    OU.ou
ORDER BY
    OU.ou

Read More»