This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 48%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
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
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?
Hi Garth
Thanks for the reply (I found your reply to a similar question as it happens on another site). I hadn't realised I was looking at the wrong query, apologies for misinformation.
Running a broad query doesn't show it in ARP. The 64 bit public preview version is definitely installed on that resource:
SELECT *
FROM v_GS_ADD_REMOVE_PROGRAMS_64 arp (or v_GS_ADD_REMOVE_PROGRAMS)
where (arp.ResourceID = '16792123' and arp.Publisher0 like '%microsoft%')
order by arp.DisplayName0
Like wise, I have also tried querying against INSTALLED_Executable and INSTALLED_Software with no result. Happy to share further screenshots or queries I am running.
I have even applied other broad queries using a WHERE to look for the specific version or even a LIKE '21%'! I'd be interested to hear if you have a similar experience.
Thanks,
Nickcx
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
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