Stan Bradley

| append [| inputlookup append=t unmanaged_high.csv where cid=* MACPrefix!=not one LocalAddressIP4=* LocalAddressIP4!=not one | rename ComputerName Due to the fact “Past Discovered Of the”| append [ inputlookup append=t unmanaged_med.csv in which cid=* MACPrefix!=nothing LocalAddressIP4=* LocalAddressIP4!=nothing | rename ComputerName Since the “Past Found Of the”]| append [| inputlookup append=t unmanaged_lowest.csv where cid=* MACPrefix!=none LocalAddressIP4=* LocalAddressIP4!=nothing | rename ComputerName As the “Last Found By the”] | append [| inputlookup notsupported.csv where cid=* MACPrefix!=none LocalAddressIP4=* LocalAddressIP4!=not one | rename ComputerName Since “Last Located From the” ] | eval “Last Seen (UTC)”=strfdate(_date, “%m/%d/%y %I:%M%p”) | fillnull really worth=null assistance | eval LocalAddressIP4=mvsort(mvdedup(split(LocalAddressIP4,” “))) | eval discoverer_services=mvsort(mvdedup(split(discoverer_aid,” “))) | eval aip=mvsort(mvdedup(split(aip,” “))) | type 0 -“Last Viewed (UTC)” | look oui.csv MACPrefix Production Name brand, ManufacturerAddress | fillnull well worth=NA Company | eval Brand=if(Manufacturer=”NA”,InterfaceDescription,Manufacturer) ]