Service Tag and host name correlation report

Reporting
1

I’m super novice when it comes to web reports and am trying to create a, hopefully, simple report.

My objective is to cross-reference the Identifying number with the computer name to see if we’ve got any assets that aren’t named correctly.

Example:
Asset service tag is 123456 so theoretically the PC should be named USWAR-123456-L. But we’ve seen circumstances where the PC is actually named something different (USWAR-135790-L)

I need to generate a report to show computers where the computer name does not contain the identifying number. Any thoughts?

2

Do you currently pull the service tag number? How are you getting this value?

3

Simply with the “Identifying Number - Windows” analysis. We’ve not run into a circumstance where this number has not been accurate