Eswar Koneti

here are the 2 blog post i have written to find the office365 activation details. http://eskonr.com/2019/09/check-microsoft-office-activation-status-using-sccm-compliance-settings/http://eskonr.com/2018/10/how-to-get-office-365-proplus-activation-status-and-excluded-apps-etc-using-sccm-configmgr/ Thanks, Eswar

Have you looked at the default software update compliance reports? they do provide similar but more granular. Thanks, Eswar

0x80072efe means "The connection with the server was terminated abnormally". Is this happening on all clients or specific machines ? can you try to restart windows update services and initate software update scan. you can start troubleshooting software updates using http://eskonr.com/2015/04/sccm-2012-troubleshoot-client-software-update-issues/ Regards, Eswar http://www.eskonr.com

This tab shows the accounts that are configured in SCCM console ,it cab be like network access account, client push account etc. Unless you configure any accounts,this tab is empty. https://docs.microsoft.com/en-us/sccm/core/plan-design/security/configure-security#BKMK_ManageAccounts Regards, Eswar www.eskonr.com

Information that you are looking for (computer name and user name) is stored in V_R_system .so it is straight forward to get the information using SQL query (given below) select name0 from v_R_System where User_Name0 like 'eswar.koneti' If you need to customize it , use the SQL views https://gallery.technet.microsoft.com/SCCM-Configmgr-2012-R2-SQL-5fefdd3b and join the tables that you need info.

I havent tried this GPO method but if you have MFA enabled ,how does this work for users when they login to onedrive for the first time. we have ADFS on-prem (first factor )and MFA enabled (2nd factor). we did not configure any GPO options to associate so would like to know on this which users to avoid entering their email id/user name into the onedrive prompt.

i have deployed onedrive for business (17.3.7076.1026) to users without using script under detection method and it works fine for me .The below information help you http://eskonr.com/2017/12/how-to-deploy-onedrive-for-business-using-configmgr/ Install program:"OneDriveSetup.exe" /silent Detection method: Hive: HKCU Key:Software\Microsoft\Windows\CurrentVersion\Uninstall\OneDriveSetup.exe Value:Displayversion Type:String Operator:Equals Value:17.3.7076.1026 Install behaviour: Install for system Logon requirement: Only when user is logged on Program visibility : Normal rest of the settings are default unless you customize. If you are deploying older or newer versions ,make changes accordingly. Give a try this way.

Properties of application and its deployment are stored in xml file in database. You need to review the xml and extract the information from it. Sample query is Avilable on my blog post http://eskonr.com/2015/05/sccm-configmgr-2012-how-to-extract-information-from-xml-file-stored-in-sql-db-for-application-properties/

You can also go work wmi query in task sequence to query the ip address or ou location or any other unique value that tell you the location of the computer.

Have you checked the SQL ports 1433 and 4022 (bi-directional) between SCCM Primary to Secondary Site ? I suspect you had firewall port issues that cause this issue.

you can try vbscript or relevant script something like this to place shortcut on users desktop http://eskonr.com/2013/04/sccm-vbscript-to-add-shortcut-files-to-users-desktop-profile-or-favorites/

Follow Niall method ,pick one client ,perform the uninstall using unattended ,put that in script/batch file ,create application/package/task sequence to remove application. SCCM follow what you feed to it

this blog post might help to understand on this ,why clients hardware inventory date stamp was taking a long time to update in the Configuration Manager Console. http://www.esebenza.com/configuration-manager/client-activity-information-refresh-in-the-configuration-manager-console/,could be something similar ?

Go through the software update dependencies link here https://docs.microsoft.com/en-us/sccm/sum/plan-design/prerequisites-for-software-updates,it has all information before you link your existing wsus to CMCB. the most recommended and to avoid any future issues ,it is good to to with New WSUS server for your CMCB ,install SUP and get your clients patched.

it looks like you have issue with proxy .Check your proxy settings and try to sync again. also check wsusctrl.log and WCM.log if your settings are correctly configured or not.