PENDING Report to know if Software is "Available" to user

[Manoj Nagarajan]

Hi ,
I have made Software in "Available" Mode. So once device name is added to collection is it possible to get a report is Software is made Available to user in Software center ? If so , can you share the query please.

Or what will be the Deployment status once the Software is made available to user ?

Regards,
Manoj Nagarajan.

 

[Prajwal Desai]

I did not understand what you want to achieve here. You want to deploy the software as soon as the machine is added to collection or just make it available ?. Under reports > software distribution you can find many built-in reports to check package and program deployments.

 

[Manoj Nagarajan]

I want to get a report if Software is made available to user or NOT .

 

[Prajwal Desai]

There is one built-in reports called All package and program deployments to specific user ?. Let me know if that helps.

 

[Manoj Nagarajan]

Thanks for your response....

I added Device D1234 to "VideoLan_VLC" Collection and it was "AVAILABLE" to user system Software Center. Now i want to get a report saying VLC is "AVAILABLE" to D1234 for Installation.

Can you pls share some SQL Query / View/ Report to get this data.




Regards,
Manoj Nagarajan
Ph: +91 9444 940 215

 

[Prajwal Desai]

Did you check that built-in report that i mentioned in previous reply ?. If not you need to write a SQL query to fetch that info. Currently i don't have any such query available with me.

 

[Manoj Nagarajan]

yes, i checked the report you mentioned earlier, but i couldnt find "AVAILABLE" status in Report.

Also, i checked in few tables in Database but couldn't find which Table is having information of application is made "AVAILABLE" for device.

Any hint please. I badly need this information to complete ServiceNow - SCCM Automation for Software Deployment. Kindly advise...


Regards,
Manoj Nagarajan.

 

[Manoj Nagarajan]

Hi Prajwal,
Can you share some hint to move forward...


Regards,
Manoj Nagarajan.

 

[Prajwal Desai]

let me know if this post helps.