Search the Community

I am trying to create an email notification that will report all the systems that completed their hardware inventory (which occurs daily) and those that haven't, and send an email notification with the status. Is this possible? Thanks

Hey, Need some quick help please guys, I'm doing a 1606 to 1702 in console upgrade that has failed on me. Error code 0x87D20b15 I had some issues initially when the nt authority\system account was called to access the sql db, which I resolved, however I can't seem to get past this error... Info Executing SQl server command <EXEC sp_RenewInvGroupViews> ERROR: Failed to renew inventory views and rbac functions Failed to Update database. Then later I get the error code noted in the title. Any ideas? I've hit a wall on this one.. I can post the whole CMUpdate.log up if you like, but there are no other errors

Hello all! Long time visitor and browse often, haven't posted much (if at all) since registering. Thanks for a great site with lots of great discussions! Here is my situation: I am working on implementing an automated way to get all our laptops onto Bitlocker. We run a Dell shop here, so I have tasks that are automating the process (which work beautifully), but for some reason my hardware inventory schedule that I have assigned to my test collections don't appear to be running on the clients assigned to that collection. The laptop that I am doing testing with does everything it's supposed to fine far as the task sequencing goes when it gets into the collection, but thus far I've only been able to get it to move collections by manually kicking off a hardware inventory on it - for some reason the schedule doesn't seem to be running the hardware inventory like I would expect (IE a TPM status change). Could anyone give me some direction to start troubleshooting this? I'm including screens of my current Client Settings. Thanks much! Chad Edit: Sorry, just realized this probably would have been better placed in Troubleshooting, tools, and tips.

Hello, I'm try to retrieve information from the registry on client workstations. I have read a few guides and sucessfully used RegKeyToMOFv3_R2 for a previous task however this time around I would like to report on data within HKey_Current_User. By default the RegKeyToMOFv3_R2 application targets HKEY_LOCAL_MACHINE. Does anyone know if the output can simply be edited to the HKCU location? Many thanks, Andy

Hi I’ve got SCCM 2012 R2 SP1 deployed with around 900 clients, all 99.9% Windows 7 Pro, at the moment, we’re still in the roll out phase. We have a problem that around 250 clients are not reporting Hardware Inventories. I can see in the InventoryAgent.log on some of the clients that the inventory seems to complete, see screenshot. I’ve looked in the dataldr.log on the server and I can see some of the following And If I look in ‘E:\Program Files\Microsoft Configuration Manager\inboxes\auth\dataldr.box\BADMIFS’ There are a few folders, both ExceedSizeLimit and NonExistentRow have 400+ MIF files.... Help! What do I need to do?

Hey Guys / Niall - I recently wrote and compiled a script which when executed on a workstation, will write a few registry strings to a custom key within the registry. The goal of this script is to inventory this data using SCCM. I think the issue I'm having is that by design, the script writes these values into a key which is named after the currently logged in user therefore is dynamic per system. I've tried using RegKeytoMOF and have looked at many pages like this one for how to add classes to inventory by editing MOF files, but haven't had luck. When using RegKeytoMOF and selecting the key named after the username, the MOF files it creates seem to populate correctly as I can clearly see each string within defined. I cannot use this as the key would be different per system so would assume I need to select the parent key. However, when I select the parent key of "ProfileInfo", the generated MOF files do not contain any settings nor mention "ProfileInfo." So - how do I go about doing this? Is the below correct? Thank you! Example of What I'm Trying to Inventory All Strings within: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Company\ProfileInfo\gwashington DocumentsSize = 100 DesktopSize = 50 MyProfile = 800 FavoritesSize = 0 AllProfilesSize = 1200 "HKLM\SOFTWARE\Wow6432Node\Company\ProfileInfo" would be the same on all PCs, but the key "gwashington" shown above is named after the logged in user so would be dynamic / different per system. All strings would be named the same within the user's key, but would obviously have different values per PC. RegKeytoMOF Output When "gwashington" Key Selected ClassGroup & ClassName set to "ProfileInfo" // RegKeyToMOF by Mark Cochrane (tribute to Skissinger & Steverac) // this section tells the inventory agent what to collect #pragma namespace ("\\\\.\\root\\cimv2") #pragma deleteclass("ProfileInfo", NOFAIL) [DYNPROPS] Class ProfileInfo { [key] string KeyName; String MyDocuments; String Desktop; String Favorites; String AppData; String MyProfile; String AllProfiles; String MyNetworkShare; }; [DYNPROPS] Instance of ProfileInfo { keyname="RegKeyToMOF[MarkCochrane]"; [PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\Company\\ProfileInfo\\gwashington|MyDocuments"),Dynamic,Provider("RegPropProv")] MyDocuments; [PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\Company\\ProfileInfo\\gwashington|Desktop"),Dynamic,Provider("RegPropProv")] Desktop; [PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\Company\\ProfileInfo\\gwashington|Favorites"),Dynamic,Provider("RegPropProv")] Favorites; [PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\Company\\ProfileInfo\\gwashington|AppData"),Dynamic,Provider("RegPropProv")] AppData; [PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\Company\\ProfileInfo\\gwashington|MyProfile"),Dynamic,Provider("RegPropProv")] MyProfile; [PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\Company\\ProfileInfo\\gwashington|AllProfiles"),Dynamic,Provider("RegPropProv")] AllProfiles; [PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\Company\\ProfileInfo\\gwashington|MyNetworkShare"),Dynamic,Provider("RegPropProv")] MyNetworkShare; }; RegKeytoMOF Output When "ProfileInfo" (Parent) Key Selected ClassGroup & ClassName set to "ProfileInfo" // RegKeyToMOF by Mark Cochrane (tribute to Skissinger & Steverac) // this section tells the inventory agent what to collect #pragma namespace ("\\\\.\\root\\cimv2") #pragma deleteclass("ProfileInfo", NOFAIL) [DYNPROPS] Class ProfileInfo { [key] string KeyName; }; [DYNPROPS] Instance of ProfileInfo { keyname="RegKeyToMOF[MarkCochrane]"; }; Thanks!

Hi, everybody! Does anybody know what is GroupID and RevisionID Columns mean? Almost of the views with hardware and software information through the SCCM DB have theese columns. THnx

I need to provide management a report of every pc we have in the organization with how much RAM, CPU, HD, Model Number, etc. Is there a report already build that will do that? I'm not familiar with creating new reports so if that is the route I need to go, I will need some assistance with that as well.

I'm asked each year to provide a list of pc's for upper management that need replaced. Each year I dread this and work through it with the information I have but it's never really that good. Is there an easy way with SCCM 2012 to run a report of pc's based on model, or better yet, warranty expiration? Usually model gets me close enough since I know they order they were purchased in. We have Dell desktops and laptops, and a few Panasonic and Fujitsu tablets. Any advise or help is appreciated.

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

I'm pretty new to building queries and am currently trying to familiarize myself with SQL and the SQL Views to further help run queries. I've been having a hard time trying to build a collection of computers that have one of our inventoried software items on it. Within Inventoried Software, I have several products with different names all containing the word Coupon. Coupon toolbars, programs, etc. These are all security threats, and I have positive software counts for each. I'd like to create a collection (or run a report) of all machines with this software installed so I can remove the software. I've tried different variations of criteria in my query statement without success. Installed software, installed application, etc. each with the product name or publisher name return no results. I'll paste my most recent attempt below: select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_SOFTWARE.ProductName like "Coupon" Any help would be appreciated!

Hi All Im after a software report in SCCM 2012 that will give me everything that the 'Software 02E - Installed Software on a specific computer' gives me but i want to exclude certain Product Family/Categorys? Anyone know if this is possible? other than exporting to Excel and manipulating Many Thanks in Advance Regards Mark

Hi I am new to SCCM 2012 and have followed all your guides and so far all is well, we have single primary server and around 700 PC's globally. the issue we have is all the asset intelligence works fine and all the hardware and software inventories scan and pull data happily for most machines apart from around 10 machines have you any ideas what i should do?