SCCM 2012 Mapped Network Printers - Hardware Inventory

[shawn.pederson]

Having trouble pulling the mapped network printers for a user; here’s what I have done so far:

 

On a test computer ran the attached (zipped) SCCM_REGINI.txt (with regini.exe) to build a registry structure to pull the users network printers (from the CURRENT_USER hive) to a hive called SCCMINV (in LOCAL_MACHINE).

 

Ran the attached VBS script (SCCM_PRINTER_INV.vbs) to copy the network printers to said hive.

 

Modified the ‘configuration.mof’ file to look in the hive for the information.

 

Modified the client agent settings to pull information (classes) from that hive.

 

I still can’t seem to find the SQL table in my SCCM DB. Anyone have any ideas on where to start?

 

I have verified the classes being copied on the test client logs:

 

All the scripts are taken from: http://myitforum.com/myitforumwp/2011/11/23/howto-printer-inventory-script-w-network-printers/

• See attached ZIP file.

And verified with: http://schadda.blogspot.se/2012/02/sccm-2012-customize-extend-hardware.html

SCCM_Printer_Inventory1.zip

[shawn.pederson]

I should also mention I have compiled the .MOF on the client as well:

 

C:\Windows\system32>mofcomp C:\temp\configuration.mof
Microsoft ® MOF Compiler Version 6.1.7600.16385
Copyright © Microsoft Corp. 1997-2006. All rights reserved.
Parsing MOF file: C:\temp\configuration.mof
MOF file has been successfully parsed
Storing data in the repository...
WARNING: File C:\temp\configuration.mof does not contain #PRAGMA AUTORECOVER.
If the WMI repository is rebuilt in the future, the contents of this MOF file wi
ll not be included in the new WMI repository.
To include this MOF file when the WMI Repository is automatically reconstructed,
place the #PRAGMA AUTORECOVER statement on the first line of the MOF file.
Done!

[GarthMJ]

There is no need to compile the configuration.mof on the clients, it will happened automatically.

 

The SQL views will be called something like v_GS_PrinterInv and v_GS_PrinterInv64

[shawn.pederson]

Thanks Garth! I had a look in there. Don't seem to see it. I see dbo.v_GS_Parallel_Port to PWR_Policy but no PRINTERINV.

 

 

 

I was also under the assumption that I would be able to see the pulled information per device under the Resource Explorer from the CCM console. However, no luck. I am terrible with SQL but my next step was to build a report then then push the above mentioned VBS/INI scripts to more computers; once I verified it is working.

[GarthMJ]

use this blog post to troubleshot the issue.

http://be.enhansoft.com/post/2013/07/25/Troubleshooting-Inventory-Flow.aspx

[shawn.pederson]

Thanks Garth, all looks well. Flows from the client to the site server then gets dumped into the DB.

 

InventoryAgent.log:

<![LOG[Collection: Namespace = root\cimv2; Query = SELECT __CLASS, __PATH, 
__RELPATH, KeyName, Comment, Default, DriverName, Local, Location, Name, 
Network, PortName, ServerName, ShareName, UserID FROM PRINTERINV; Timeout = 600 
secs.]LOG]!><time="15:56:28.981+360" date="08-07-2013" 
component="InventoryAgent" context="" type="1" thread="6628" 
file="collectiontask.cpp:478">

DATALDR.LOG on Site Server:

Done: Machine=SPEDERSON(GUID:05875980-F038-4B2C-ADC3-B92CB0F6EA1B) code=0 
(105 stored procs in XH3PYAYJI.MIF)

I'm stuck...

[GarthMJ]

So has your Resource Explorer not updated with a new data and time?

[shawn.pederson]

Yes it did update. It says last updated 30 minutes ago under the Workstation Status node. However, the PRINTERINV information is no where to be found.

[GarthMJ]

Just to be clean. The workstation status data and time has not updated? I'm not interested in the printer stuff yet.

[shawn.pederson]

Sorry... yes the status time did update. My last post was confusing.