Open SCCM console, navigate to Site Database->Computer management->Reporting and click on reports where all the required reports will be listed. Right click on any report and click run to EXECUTE the report (assuming that the report is already been created).

In the below SCREENSHOT “All advertisements for a Specific computer” has been executed.

The client computer name has been entered and click on display to run the query and the ADVERTISEMENT for the specific client will be displayed as SHOWN below.

Click on “Export” option as shown below to export the result to the excel sheet.

Open SCCM console, navigate to Site Database->Computer management->Reporting and click on reports where all the required reports will be listed. Right click on any report and click run to execute the report (assuming that the report is already been created).

In the below screenshot “All advertisements for a Specific computer” has been executed.

The client computer name has been entered and click on display to run the query and the advertisement for the specific client will be displayed as shown below.

Click on “Export” option as shown below to export the result to the excel sheet.