Discovery not populating "Assigned To" user in CMDB

Dead Blade
Kilo Guru

I know the name of the probe that is suppose to populate the CMDB:   Windows - OS Information / Win32_ComputerSystem.UserName

But this has never worked.   I check the other post and I have computers with the "In Use" state, so that's not it.

I am wondering how to I enable this function to work.   It is currently set to Active and discovery is running on the workstations.

1 ACCEPTED SOLUTION

Patrick DeCarl1
ServiceNow Employee
ServiceNow Employee

Hi William,



OOTB property "glide.discovery.assigned_user_match_field" is set to use "user_name" field on the "sys_user" table to match the value discovery pulls back. If that value doesnt match what your system has, then you might need to change what field to use from sys_user to sync up.



All this can be found in the sensor of the probe.


View solution in original post

46 REPLIES 46

We are suppose to.   Do the results reflect limited access?


It doesn't but nothing in the result section for user name.


I just verified on my own pc.   Our SN service account is added to the local admin.



Ok so no result for section for user name, what do you think my next step should be?


Can you run a single scan on your pc? Then review the input payload and see if user data is coming back.


I found one that appears to have worked (blanked out the last name, Bradley.****)   :



<?xml version="1.0" encoding="UTF-8"?><results probe_time="27144" result_code="0"><result><Win32_Processor><AddressWidth>64</AddressWidth></Win32_Processor><Win32_ComputerSystem><Manufacturer>LENOVO</Manufacturer><Model>20BHS0NV00</Model><UserName>CORP\bradley.******</UserName></Win32_ComputerSystem><Win32_OperatingSystem><Version>6.1.7601</Version><CSDVersion>Service Pack 1</CSDVersion><Description/></Win32_OperatingSystem></result><parameters><parameter name="mid_selector_details" value="{&quot;mode&quot;:&quot;specific_mid&quot;}"/><parameter name="agent" value="mid.server.MID-Jepp-Den"/><parameter name="glide.xmlhelper.trim.enable" value="true"/><parameter name="runner_type" value="Powershell"/><parameter name="source" value="10.1.107.142"/><parameter name="probe_results_hash" value="hEmvLmwKTuYkZAFF+Q3k6Q=="/><parameter name="WMI_FetchData" value="Win32_Processor.AddressWidth,Win32_ComputerSystem.Manufacturer,Win32_ComputerSystem.Model,Win32_ComputerSystem.UserName,Win32_OperatingSystem.Version,Win32_OperatingSystem.CSDVersion,Win32_OperatingSystem.Description"/><parameter name="sys_id" value="ebcbeff5db58474000a0ffd31d961965"/><parameter name="protocol" value="WMI"/><parameter name="from_host" value=""/><parameter name="sys_created_on" value="2017-08-01 16:09:09"/><parameter name="used_by_discovery" value="true"/><parameter name="ci_sys_id" value="1f10c0b83787a6005887c97a43990e6b"/><parameter name="GenerateWMIScriptPS1_WMI_FetchData.PS1" value="addFetch('Win32_Processor.AddressWidth');&#10;addFetch('Win32_ComputerSystem.Manufacturer');&#10;addFetch('Win32_ComputerSystem.Model');&#10;addFetch('Win32_ComputerSystem.UserName');&#10;addFetch('Win32_OperatingSystem.Version');&#10;addFetch('Win32_OperatingSystem.CSDVersion');&#10;addFetch('Win32_OperatingSystem.Description');&#10;fetch -computer $computer -cred $cred;&#10;"/><parameter name="state" value="ready"/><parameter name="probe_name" value="Windows - OS Information"/><parameter name="response_to" value="b9cb6ff5db58474000a0ffd31d961971"/><parameter name="from_sys_id" value=""/><parameter name="priority" value="2"/><parameter name="agent_correlator" value="3ab9abf1db980340ced2f1e51d961954"/><parameter name="probe" value="6325f3ef0a0006bc3e2e2d83e75dc02a"/><parameter name="processed" value=""/><parameter name="error_string" value=""/><parameter name="sequence" value="15d9e8edfb50000001"/><parameter name="port" value="135"/><parameter name="os_type" value="WINDOWS"/><parameter name="name" value="WMI: OS Information (nodes: 3)"/><parameter name="topic" value="WMIRunner"/><parameter name="queue" value="output"/><parameter name="ecc_queue" value="ebcbeff5db58474000a0ffd31d961965"/><parameter name="credential_id" value="3951de256f323100075a9f5e5d3ee440"/></parameters></results>