Using CMPivot in SCCM for Real-Time Data and Taking Real-Time Action Using Scripts

[@francydevicemanagement]

Perfectly explained! thank you for this

[@PatchMyPC]

Thanks for watching

[@Shizdenn]

Great material for insights into CMPivot. Thanks Justin!

[@PatchMyPC]

Thanks for watching

[@TheMunzie]

Thank you for continuing SCCM series !!!! I look forward to them

[@PatchMyPC]

Thanks for watching

[@DamagedDingo]

Patch My PC but what are the chances of having all your devices turned on. Wouldn’t a CB be a better option for all of this?

[@PatchMyPC]

@@DamagedDingo if it's not on, it can pull the last available data from HW inventory.

[@DamagedDingo]

Patch My PC but the scripts that you ran against it wouldn’t work for ones that are off still. So again wouldn’t a can be better as it would run when connected.

[@PatchMyPC]

@@DamagedDingo If there's a better scenario for how this could work for offline devices, I'm sure the product group would love to hear your idea on their UserVoice over at configurationmanager.uservoice.com/forums/300492-ideas/

[@kshitijjgulati]

Thanks a lot. I was waiting for this:)

[@PatchMyPC]

You're welcome!

[@M.J.C.W.]

Ty Sir. I have been waiting for this video

[@PatchMyPC]

You're welcome!

[@imranawan9341]

Thanks for the video. Great your making some new ones now. Please bring them back. So you created a qurey Administrators | where PrincipalSource == 'local' is there a way to get it for only windows 10 devices

[@PatchMyPC]

Run it against a WIndows 10 device collection.

[@imranawan9341]

@@PatchMyPC thanks I will do that. Do we have this option on sccm 1902. Also look forward to see you in London. Your coming SCConfigMgr - Modern Management Summit

[@PatchMyPC]

@@imranawan9341 yeah, CMPivot has been out since 1806.

[@suyoggurav8618]

Thank you 🙏

[@jesseted360]

How to do export the dcount. i export but the result no taking the dcount. (script i running--> InstalledSoftware | summarize dcount( Device ) by ProductName)

[@vinodpandit8293]

Can you please provide the scripts if possible

[@PatchMyPC]

I will need to take a look at what scripts I used.

[@vinodpandit8293]

Or any scripts related to CMpivot will be highly thankful

[@yogeshgupta1991]

Hi Justin can we use wild cards

[@PatchMyPC]

Should be able to.

[@vinodpandit8293]

Can you help me with the SQL query in which I want to know each devices connected on a laptop

[@PatchMyPC]

I'm sure this is in one of the default query options.

[@vinodpandit8293]

@@PatchMyPC okay I got the solution thanx. need ur help as in my organization I want to install java 202 to the machine n remove older version java8 171 at the same time do you have any solution for this if so kindly help

[@soundarya9195]

when i give a installedSoftware query it shows only microsoft application sir it didnt show all the application what to do sir

[@PatchMyPC]

Did you figure this out? Not sure I have enough info to help here.

[@olegproscurchin8200]

Our PS execution policy is set to All Signed, does it mean that I won't be able to use CMPivot? It fails with Unsupported PS Version error.

[@PatchMyPC]

Not sure if that would be from signing or your script

[@olegproscurchin8200]

Patch My PC - I’m just running a basic command and it fails on all PCs. Example: “Installed Software”. Instead I have a few machines with Unrestricted policy and it run successfully. So I’m pretty sure it’s the policy 😢

[@olegproscurchin8200]

“InstalledSoftware” sorry with no space.

[@PatchMyPC]

@@olegproscurchin8200 docs.microsoft.com/en-us/sccm/core/servers/manage/cmpivot#prerequisites | Target clients require a minimum of PowerShell version 4.

[@olegproscurchin8200]

Patch My PC we are on ver.5. I think there is a limitation with policy github.com/MicrosoftDocs/SCCMdocs/issues/1750

[@J03LRl0S]

Where are all your awesome scripts. Trying to clean up old versions of software sucks without gathering all the awful product codes or calling for dangerous WMI uninstall commands.

[@PatchMyPC]

Here you go setupconfigmgr.com/how-to-create-manage-and-deploy-applications-in-microsoft-sccm forgot to include it in the KZbin description.