[et_pb_section fb_built=”1″ admin_label=”Page Title” _builder_version=”4.9.3″ background_color=”#667077″ use_background_color_gradient=”on” custom_padding=”75px||75px|” global_module=”210146″ collapsed=”off”][et_pb_row _builder_version=”3.25″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”0px||0px|”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_post_title meta=”off” featured_image=”off” text_color=”light” _builder_version=”4.9.3″ title_font=”Poppins|600|||||||” title_text_align=”center” title_text_color=”#ffffff” title_font_size=”50px” text_orientation=”center” title_font_size_tablet=”” title_font_size_phone=”40px” title_font_size_last_edited=”on|phone”][/et_pb_post_title][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.9.3″ _module_preset=”default” background_color=”#f4f4f4″][et_pb_row column_structure=”3_4,1_4″ _builder_version=”4.9.3″ _module_preset=”default” custom_padding=”||6px|||”][et_pb_column type=”3_4″ _builder_version=”4.9.3″ _module_preset=”default”][et_pb_text admin_label=”Title Block” _builder_version=”4.9.3″ _module_preset=”default” text_text_color=”#0a0a0a” text_font_size=”14px” header_font=”Poppins|800|||||||” header_text_color=”#444444″ header_font_size=”28px” header_letter_spacing=”1px”]
Sometimes the Built-In SCCM Report Just Doesn’t Show What You Need
As part of a project, we wanted to take a batch of domain-joined laptops and manage them through Intune and Autopilot.
To enroll the devices, Intune needs certain info off of each computer. We installed the ConfigMgr client on each machine to get a hardware inventory list of each.
This turned out to be a better idea than we’d thought at the time.
[/et_pb_text][et_pb_text admin_label=”Title Block” _builder_version=”4.9.3″ _module_preset=”default” text_text_color=”#0a0a0a” text_font_size=”14px” header_text_color=”#444444″ header_font_size=”28px” header_2_font=”|600|||||||” header_2_font_size=”30px” header_2_letter_spacing=”1px” header_3_font_size=”24px” header_3_letter_spacing=”1px” hover_enabled=”0″ sticky_enabled=”0″]
Doesn’t ConfigMgr Have a Built-In Report For This?
Yes, it does!
Under Reports > Hardware – General is a report, Windows Autopilot Device Information.
However, this isn’t exactly what we needed. We had a customized script that could pull all of the Autopilot info off of a machine, but what I wanted was:
- Only the machines we were enrolling into Autopilot, and
- The list needed to show computer names
[/et_pb_text][/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.9.3″ _module_preset=”default”][et_pb_team_member image_url=”https://craigtwall.com/wp-content/uploads/2019/01/Craig-Transparent-300×300.png” facebook_url=”https://www.facebook.com/craig.wall.7″ twitter_url=”https://twitter.com/craigtwall” linkedin_url=”https://www.linkedin.com/in/craigtwall/” _builder_version=”4.9.3″ _module_preset=”default” header_font=”||||||||” header_text_align=”center” body_font=”Poppins||||||||” body_text_color=”#000000″ hover_enabled=”0″ custom_css_main_element=”display:block;||margin-left:auto;||margin-right:auto;||width: 70%;||text-align:center;||” sticky_enabled=”0″]
Craig Wall is a public sector systems administrator with experience in deployment and print management.
[/et_pb_team_member][/et_pb_column][/et_pb_row][et_pb_row admin_label=”One Column” _builder_version=”4.9.3″ _module_preset=”default”][et_pb_column type=”4_4″ _builder_version=”4.9.3″ _module_preset=”default”][et_pb_text admin_label=”Title Block” _builder_version=”4.9.3″ _module_preset=”default” text_text_color=”#0a0a0a” text_font_size=”14px” header_text_color=”#444444″ header_font_size=”28px” header_2_font=”|600|||||||” header_2_font_size=”30px” header_2_letter_spacing=”1px” header_3_font_size=”24px” header_3_letter_spacing=”1px”]
Why We Needed The Report
Because of the way we had the devices domain-joined beforehand, and our plan to get them done as remotely as possible, we needed to make sure we could easily match up the domain-joined, pre-enrollment names with the device serial.
The hardware hash for each in this case may only be necessary in certain situations — we had a customized script for our environment to pull that info.
However, I’m always game to work on my reporting skills.
[/et_pb_text][et_pb_text admin_label=”Title Block” _builder_version=”4.9.3″ _module_preset=”default” text_text_color=”#0a0a0a” text_font_size=”14px” header_text_color=”#444444″ header_font_size=”28px” header_2_font=”|600|||||||” header_2_font_size=”30px” header_2_letter_spacing=”1px” header_3_font_size=”24px” header_3_letter_spacing=”1px”]
The Tables/Views Needed
- Hardware Hash: v_GS_MDM_DEVDETAIL_EXT01 (DeviceHardwareData0)
- Serial Number: v_GS_SYSTEM_ENCLOSURE (SerialNumber0)
- Computer Name: v_GS_SYSTEM (Name0)
[/et_pb_text][et_pb_text admin_label=”Title Block” _builder_version=”4.9.3″ _module_preset=”default” text_text_color=”#0a0a0a” text_font_size=”14px” header_text_color=”#444444″ header_font_size=”28px” header_2_font=”|600|||||||” header_2_font_size=”30px” header_2_letter_spacing=”1px” header_3_font_size=”24px” header_3_letter_spacing=”1px”]
The SQL Query
SELECT v_GS_SYSTEM.ResourceID AS [v_GS_SYSTEM ResourceID],v_GS_SYSTEM.Name0,v_GS_MDM_DEVDETAIL_EXT01.ResourceID AS [v_GS_MDM_DEVDETAIL_EXT01 ResourceID],v_GS_MDM_DEVDETAIL_EXT01.DeviceHardwareData0,v_GS_SYSTEM_ENCLOSURE.ResourceID AS [v_GS_SYSTEM_ENCLOSURE ResourceID],v_GS_SYSTEM_ENCLOSURE.SerialNumber0 FROM v_GS_SYSTEM INNER JOIN v_GS_MDM_DEVDETAIL_EXT01 ON v_GS_SYSTEM.ResourceID = v_GS_MDM_DEVDETAIL_EXT01.ResourceID INNER JOIN v_GS_SYSTEM_ENCLOSURE ON v_GS_SYSTEM.ResourceID = v_GS_SYSTEM_ENCLOSURE.ResourceID WHERE (v_GS_SYSTEM.Name0 like 'LAPTOP%')
[/et_pb_text][et_pb_text admin_label=”Title Block” _builder_version=”4.9.3″ _module_preset=”default” text_text_color=”#0a0a0a” text_font_size=”14px” header_text_color=”#444444″ header_font_size=”28px” header_2_font=”|600|||||||” header_2_font_size=”30px” header_2_letter_spacing=”1px” header_3_font_size=”24px” header_3_letter_spacing=”1px” hover_enabled=”0″ sticky_enabled=”0″]
The Output
I whipped up a quick table in Report Builder for this.
Because the hashes are so long, I didn’t want all of them listed in one big mess. So I left grouping on for the table.
This resulted in each computer being its own “group” in the table — I had to click the + icon next to each laptop to expand the row and show the serial and hash.
This worked out well for the specific use of this report, but the report couldn’t be emailed to anyone because those + signs don’t show up in the report email — something to watch for if you were going to send a report in the email instead of sending the report URL.
[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure=”1_2,1_2″ admin_label=”Blog Footer” _builder_version=”4.9.3″ _module_preset=”default” background_color=”#3749b2″ use_background_color_gradient=”on” background_color_gradient_start=”#3749b2″ background_color_gradient_end=”#4133bf” custom_padding=”0px||0px||false|false” box_shadow_style=”preset3″][et_pb_column type=”1_2″ _builder_version=”4.9.3″ _module_preset=”default”][et_pb_text admin_label=”Title Block” _builder_version=”4.9.3″ _module_preset=”default” text_text_color=”#f4f4f4″ text_font_size=”14px” header_text_color=”#FFFFFF” header_font_size=”28px” header_2_font=”|600|||||||” header_2_text_color=”#f4f4f4″ header_2_font_size=”32px” header_2_letter_spacing=”1px” header_3_font_size=”24px” header_3_letter_spacing=”1px” background_color=”#3749b2″ custom_padding=”10px|10px|10px|10px|true|true”]
More Posts Like This
[/et_pb_text][et_pb_blog posts_number=”3″ include_categories=”111,112″ show_thumbnail=”off” use_manual_excerpt=”off” show_author=”off” show_excerpt=”off” show_pagination=”off” offset_number=”1″ _builder_version=”4.9.3″ _module_preset=”default” header_text_color=”#f4f4f4″ header_font_size=”15px” header_letter_spacing=”1px” meta_text_color=”#f4f4f4″ meta_font_size=”12px” meta_line_height=”1.2em” custom_padding=”10px|10px|10px|10px|true|true” hover_enabled=”0″ sticky_enabled=”0″][/et_pb_blog][/et_pb_column][et_pb_column type=”1_2″ _builder_version=”4.9.3″ _module_preset=”default”][et_pb_text admin_label=”Title Block” _builder_version=”4.9.3″ _module_preset=”default” text_text_color=”#f4f4f4″ text_font_size=”14px” header_text_color=”#FFFFFF” header_font_size=”28px” header_2_font=”|600|||||||” header_2_text_color=”#f4f4f4″ header_2_font_size=”32px” header_2_letter_spacing=”1px” header_3_font_size=”24px” header_3_letter_spacing=”1px” background_color=”#3749b2″ custom_padding=”10px|10px|10px|10px|true|true”]
More From Craig
[/et_pb_text][et_pb_blog posts_number=”3″ include_categories=”all” show_thumbnail=”off” use_manual_excerpt=”off” show_author=”off” show_excerpt=”off” show_pagination=”off” offset_number=”1″ _builder_version=”4.9.3″ _module_preset=”default” header_text_color=”#f4f4f4″ header_font_size=”15px” header_letter_spacing=”1px” meta_text_color=”#f4f4f4″ meta_font_size=”12px” meta_line_height=”1.2em” custom_padding=”10px|10px|10px|10px|true|true” hover_enabled=”0″ sticky_enabled=”0″][/et_pb_blog][/et_pb_column][/et_pb_row][/et_pb_section]