MEMCM report on OneDrive

NkCX 36

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

1 answer

Garth 5,801 Reputation points

2021-06-30T11:09:34.083+00:00

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?
Please sign in to rate this answer.
NkCX 36 Reputation points

2021-06-30T11:31:54.597+00:00

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

NkCX 36 Reputation points

2021-06-30T11:35:37.46+00:00

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

Kalyan Sundar 561 Reputation points

2021-06-30T13:05:56.91+00:00

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

Garth Jones 2,071 Reputation points

2021-06-30T13:44:45.337+00:00

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/

NkCX 36 Reputation points

2021-07-01T14:50:14.467+00:00

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