- #Wmic desktopmonitor get serial number serial numbers
- #Wmic desktopmonitor get serial number update
- #Wmic desktopmonitor get serial number full
#Wmic desktopmonitor get serial number full
JOIN v_R_System syst ON cnvt.ResourceID = syst.Powershell PARAM ( ] $ComputerName = $env:ComputerName ) #List of Manufacture Codes that could be pulled from WMI and their respective full names.
#Wmic desktopmonitor get serial number update
UPDATE SET UserFriendlyNameConv = WHERE UserFriendlyName0 = NEXT FROM convert_cursor into convert_cursor
UPDATE SET SerialNumberIDConv = WHERE SerialNumberID0 = sp_executesql OUTPUT UPDATE SET ProductCodeIDConv = WHERE ProductCodeID0 = sp_executesql OUTPUT UPDATE SET ManufacturerNameConv = WHERE ManufacturerName0 = sp_executesql OUTPUT SELECT ManufacturerName0, ProductCodeID0, SerialNumberID0,UserFriendlyName0 FROM varchar(255), varchar(255), varchar(255), varchar(255)įETCH NEXT FROM convert_cursor INTO = 0 (SELECT ResourceID FROM v_FullCollectionMembership WHERE CollectionID = Cursor to iterate through table variable and convert UserFriendlyName0, UserFriendlyNameLength0, WeekOfManufacture0, YearOfManufacture0 ResourceID, InstanceName0, ManufacturerName0, ProductCodeID0, SerialNumberID0, UserFriendlyName0, UserFriendlyNameLength0, WeekOfManufacture0, YearOfManufacture0)
INSERT InstanceName0, ManufacturerName0, ProductCodeID0, SerialNumberID0, select data to report on, into the table variable If you choose to do the later remember to modify the description and tile fields as well a s all the sorting rules/names of the data fields and al the other references to the values from the old report you de cided to use as a template. again depending on your needs, either create a brand new report, or, which is what I deci ded to do, use one of the built-in Microsoft reports, preferable the one wit h a drop-down list of device collections and swap the T-SQL query with the one shown below. With the use of Report Builder installed on your SCCM server you can. Next step is w here the T- SQL query comes in play.
#Wmic desktopmonitor get serial number serial numbers
Then deploy this custom setting to the collect ion of co mputers, that you would like to obtain the serial numbers for. I would however recommend to leave it unticked here and create ad ditional Custom Client Device Settings, where you add this particular class to Hardware Inventory process. You can tick the box in here, and thus start collecting this WMI class from all the systems in your organization right away.
0 kommentar(er)
