question

NickCX-2258 avatar image
0 Votes"
NickCX-2258 asked NickCX-2258 commented

MEMCM report on OneDrive

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

110587-image.png


mem-cm-general
image.png (6.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Garth avatar image
0 Votes"
Garth answered NickCX-2258 commented

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?

· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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:

110590-image.png

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



0 Votes 0 ·
image.png (11.5 KiB)

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/

1 Vote 1 ·

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

0 Votes 0 ·

PS Count of all instances of software registered with Add or Remove Programs doesn't provide any info either. It's even worse :)

0 Votes 0 ·