Search the Community

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

I'm Having a little trouble writing a report. My goal is to report back the following fields: Last Time the Hardware inventory was run, Computer Name, Asset Tag (Bios Serial Number), IP Address, Operating System, OS Service Pack level, time the computer was Last Rebooted, Last Logged in User, Domain Name, OU, and AD Site. I've managed to gather most everything but I'm getting duplicate entries. My report returns over 13000 rows when I only have 6000 clients. Much of this is coming from the IP Address field since if the computer has an IPv6 address it returns another row. Below is my query and I appreciate any help anyone can give since I am very much a beginner in SQL. SELECT DISTINCT v_GS_Workstation_Status.LastHWScan, v_R_System.Netbios_Name0, v_GS_PC_BIOS.SerialNumber0, v_RA_System_IPAddresses.IP_Addresses0, v_GS_Operating_System.Caption0 as C054, v_GS_Operating_System.Version0, v_GS_Operating_System.LastBootUpTime0, v_R_System.User_Name0, v_R_System.Resource_Domain_OR_Workgr0, v_R_System.AD_Site_Name0 FROM v_R_System JOIN v_GS_Workstation_Status on v_R_System.ResourceID = v_GS_Workstation_Status.ResourceID JOIN v_RA_System_IPAddresses on v_R_System.ResourceID = v_RA_System_IPAddresses.ResourceID JOIN v_GS_PC_BIOS on v_R_System.ResourceID = v_GS_PC_BIOS.ResourceID JOIN v_GS_OPERATING_SYSTEM on v_R_System.ResourceID = v_GS_Operating_System.ResourceID ORDER BY v_GS_Workstation_Status.LastHWScan, v_R_System.Netbios_Name0, v_GS_PC_BIOS.SerialNumber0, v_RA_System_IPAddresses.IP_Addresses0, v_GS_Operating_System.Caption0, v_GS_Operating_System.Version0, v_GS_Operating_System.LastBootUpTime0, v_R_System.User_Name0, v_R_System.Resource_Domain_OR_Workgr0, v_R_System.AD_Site_Name0

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.