If you are getting the result you need for arp, it will tell you if it is x86 or x64 from these details. So why do you say that it doesn't?
MEMCM report on OneDrive

NickCX
36
Reputation points
Hi,
I'm looking to run a SQL query against the MEMCM DB to report the versions and architecture of OD4B installed in my W10 x64 estate. I have various OD versions mainly x86 and a few x64, who are running a pilot with the public preview. I want to extend the pilot to move some x86 to 64 but also want to monitor the uptake for the auto-update of the rest of the estate when it hits.
I can query installed executable and ARP etc but I don't get the architecture - unless I am missing something (which I may be!)
Thanks in advance,
NC
PS Count of all instances of software registered with Add or Remove Programs doesn't provide any info either. It's even worse :)
Enable installed_sofwtare class and try again, check the below thread
https://social.technet.microsoft.com/Forums/lync/en-US/fa6e83cd-6da6-4157-b449-030866a0f206/vgsinstalledsoftware-empty?forum=ConfigMgrCBGeneral
OneDrive might be a user installed SW title and as such CM will not collect these SW titles. You will need to look at third party tools for this then. I wrote a blog on the subject a while back. https://www.enhansoft.com/user-installed-software-and-why-you-should-care/
Aha..So it is :). Silly me.
So I went about and wrote a script and deployed as a compliance baseline. It'll query a running OD user process and give things like whether it's 64 or 32 bit and what version it is compared to my required version ... it's a little quick and dirty but does what I need...
Thanks,
Nickcx
Sign in to comment