SOLVED How can I extract a software report by team and export it to Excel using Intune?

[emanuel]

For example:
y/o

 

[Garth]

have you looked at the exporting a report from Intune? Then you can do what every you want with it? In power bi or excel. https://askgarth.com/blog/configmgr-client-health-start-up-script/

 

[emanuel]

have you looked at the exporting a report from Intune? Then you can do what every you want with it? In power bi or excel. https://askgarth.com/blog/configmgr-client-health-start-up-script/

Hi Garth;
The issue is that Intune extracts reports but from one computer at a time, not all computers at the same time; or am I missing something?

Thank you

 

[Garth]

Hi Garth;
The issue is that Intune extracts reports but from one computer at a time, not all computers at the same time; or am I missing something?

Thank you

Sorry it took me a while to find this, this morning but yes you can get the raw data. https://learn.microsoft.com/en-us/mem/intune/apps/app-discovered-apps

I think that I should do a blog on this.

 

[hina]

hi Garth, please i need help to get the software inventory for my company devices to keep track of the licenses. is there anyway i can do it with SCCM or through cmd
help is much appreciated.

 

[emanuel]

Sorry it took me a while to find this, this morning but yes you can get the raw data. https://learn.microsoft.com/en-us/mem/intune/apps/app-discovered-apps

I think that I should do a blog on this.

Hi Garth;
Actually what I need is to extract a report like the image I attached, with that structure, since extracting a report device by device if possible; What I want to do is extract a report where all the devices are and on the right side all the applications that each device has.
Thank you

 

[emanuel]

hi Garth, please i need help to get the software inventory for my company devices to keep track of the licenses. is there anyway i can do it with SCCM or through cmd
help is much appreciated.

Hi Hina
From my experience, in SCCM you can extract a software report by querying the Database:
SELECT
SYS.Netbios_Name0 AS 'Nombre del dispositivo',
ARP.DisplayName0 AS 'Nombre de la aplicación',
ARP.Version0 AS 'Versión'
FROM
v_R_System SYS
INNER JOIN
v_Add_Remove_Programs ARP ON SYS.ResourceID = ARP.ResourceID
ORDER BY
SYS.Netbios_Name0, ARP.DisplayName0

 

[hina]

Hi Hina
From my experience, in SCCM you can extract a software report by querying the Database:
SELECT
SYS.Netbios_Name0 AS 'Nombre del dispositivo',
ARP.DisplayName0 AS 'Nombre de la aplicación',
ARP.Version0 AS 'Versión'
FROM
v_R_System SYS
INNER JOIN
v_Add_Remove_Programs ARP ON SYS.ResourceID = ARP.ResourceID
ORDER BY
SYS.Netbios_Name0, ARP.DisplayName0

thank you so much for help i'll test it right now

 

[hina]

thank you so much for help i'll test it right now

@emanuel may i know if you have pulled your software inventory list through sccm aswell

 

[emanuel]

@emanuel may i know if you have pulled your software inventory list through sccm aswell

Yes, it doesn't work for you? Remember that you must do it in the same SCCM DB, in SQL. You create a query and tell it to show the output in a grid. You go to the grid, copy everything and paste it into an excel.

 

[hina]

Yes, it doesn't work for you? Remember that you must do it in the same SCCM DB, in SQL. You create a query and tell it to show the output in a grid. You go to the grid, copy everything and paste it into an excel.

i am not sure if i am doing something wrong to run the query but its not working

 

[emanuel]

i am not sure if i am doing something wrong to run the query but its not working

The values and names that I have given you are the ones I have, check the tables for the names they have in your database

 

[Garth]

hi Garth, please i need help to get the software inventory for my company devices to keep track of the licenses. is there anyway i can do it with SCCM or through cmd
help is much appreciated.

what is wrong with the built in reports for this?

 

[Garth]

Hi Garth;
Actually what I need is to extract a report like the image I attached, with that structure, since extracting a report device by device if possible; What I want to do is extract a report where all the devices are and on the right side all the applications that each device has.
Thank you

but this report will allow you to do this.... Did you try it?

 

[Garth]

i am not sure if i am doing something wrong to run the query but its not working

The query is for Sql not for cmpivot. But look at the built in reports.

 

[Harshit Pandey]

I think built-in report is available for this.