Search the Community

Hi, I'm attempting to construct a report, which counts computers by Active directory Ou in sccm 2012sp1. So far I have found only http://www.systemcentercentral.com/sccm-reportingadding-the-system-ou-as-a-column/ as a reference, but for some reason the following query SELECT TOP (100) PERCENT COUNT(sys.Netbios_Name0) AS Computers, (SELECT TOP (1) System_OU_Name0 FROM dbo.v_RA_System_SystemOUName AS ou2 WHERE (ou.ResourceID = ResourceID) AND (LEN(System_OU_Name0) = MAX(LEN(ou.System_OU_Name0)))) AS [Org.unit] FROM dbo.v_R_System_Valid AS sys INNER JOIN dbo.v_RA_System_SystemOUName AS ou ON sys.ResourceID = ou.ResourceID GROUP BY ou.ResourceID HAVING ((SELECT TOP (1) System_OU_Name0 FROM dbo.v_RA_System_SystemOUName AS ou2 WHERE (ou.ResourceID = ResourceID) AND (LEN(System_OU_Name0) = MAX(LEN(ou.System_OU_Name0)))) = N'domain.local/computers/staff/office-x/room-y') ORDER BY Computers calculates only 6, when such OU ( domain.local/comptuers/staff/office-x/room-y) has 14 computer objects. While SELECT distinct count ( v_R_System.Name0 ) as count_of_computers ,v_RA_System_SystemOUName.System_OU_Name0 as Ouname FROM v_R_System INNER JOIN v_RA_System_SystemOUName ON v_R_System.ResourceID = v_RA_System_SystemOUName.ResourceID Group by v_RA_system_systemouname.System_ou_name0, v_r_system.name0 HAVING v_RA_System_SystemOUName.System_OU_Name0 LIKE N'domain.local/computers/staff/office-x/room-y' shows even less number of computers in Ou, but if I omit distinct, the number of rows matches the computers... :/ I know, there IS easier way to accomplish the results, but this seems to be hard... I'm also aware, that changes made in AD are not immediately efective in SCCM database reports. This is not a problem. In our scenario, structure for computers is computers/type-of-comptuer/office/room/spec and I'd like to know How many computers I do have in room ou. Thanks for advices. ~T

I am wondering if there is a report or way to meter print jobs. We are looking to identify users that are costing our company an abnormal amount of money through high volume printing. I know there are other applications out there that do this, but we would like to utilize what we have. We are currently running 2007 and are in the middle of migrating to 2012 SP1. Thanks Kev

Hi, I have requirement from management to provide a report to show who has MS office Access 2010/2007 installed on their machine using SCCM 2012. The only thing I can find on user machine is "Microsoft Office Access MUI 2010/2007" which doesn't verify that it's installed or not. I used another report (Computers with a specific file) to list all machines that have "MSACCESS.EXE" on them, but also I found out that some users have "Microsoft Office Access Runtime 2010/2007" installed on them which are showing in the report also. Is there any way of getting such information, instead of manually comparing 4 different reports which is taking too much time, I have over 1200 computers managed by SCCM. Appreciate you help in this matter.

Hello, I am new to SCCM and would like to know, how would i produce a report or a see a list of computers that received the Java update?

I need to find the following variable (last characters changed) that is located in the registry and need to create a report or collection if any machines have this value in it. What would be the best way of doing this? Has anyone done this before or have any scripts that can pull this information? Would it be easier to create a program to perform a search through the registry and if it's successful to post it's computer name as a text file to a specific open shared folder (not sure if this is possible, sure it is not even sure how to do it just thinking..) Computer\HKEY_Local_Machine\Software\Policies\Microsoft\SystemCertificates\Root\Certificates\AY600DXAIEJANENUEE Thanks,

Does anyone have an idea on this one?

Hi, I've come across a Report Builder issue, which is quite baffling. I have installed Report builder 3 , and two in the meantime, and tried the fixes as below, switching between two and three respectively within registry, but no luck I've also tried to launch configmgr as local administrator, and two domain admin accounts on two seperate domains, and still no luck, please advise. http://social.techne...4e-329698a917f2 Thanks. Coenie

Hi there, WQL and SQL totally escapes me so I was wondering if someone could help. I'm after creating a report that will show users that have logged on to multiple machines and also list these machines... My Project manager asked spcifically for a report that displays users that have (in their possession) both a desktop and a laptop but I'm guessing my method would be easier. I believe you can also report on the primary user depending on the % of time a user has been logged on to a machine - maybe this could help narrow the results down further?? Hope someone can help - or at least understand my request ) Chris.

Hi, Could someone please help me better understand how the compliance report actually determines which machines are compliant and not compliant. i have a sccm 2007 r3 wsus and mdt 2010 integration environment.... we have around 75% machines compliant and around 20% machines none compliant and the rest unknown. ive gone through the logs of machines and machines are receiving windows updates but i cannot workout what actually determines machine from being compliant and not compliant.... i need to have the compliance above 90% to keep the managers happy. any help would be appreciated. thank you

We have several DPs on different places. These DPs are used to do OSD too. Is there a report that tells me that all packages from a specific TS are synchronised on a specific DP? I was thinking of a report that gives a fill in box where you put the name of the task sequence -> it gives you all DP names where you can click on which you want -> gives the packages from that task sequence and if it's installed yes or no.