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.

I would suggest to create configuration baseline to clean the ccmcache either fully or if size is less than x my, something like that and schedule to run the job weekly once or monthly once depends on the needs. Read the blog post for complete solution http://eskonr.com/2016/08/sccm-configmgr-how-to-clean-ccmcache-content-older-than-x-days-using-compliance-settings/ Regards Eswar Www.eskonr.com

similar but can take input as title ,bulletin ID or article ID http://eskonr.com/2015/03/configmgr-2012-check-patch-is-member-of-what-software-update-package/

i would look at enhansoft for warranty information http://www.enhansoft.com/product/warranty-information-reporting for some custom solution.

you can refer this guide http://www.techrepublic.com/blog/the-enterprise-cloud/making-sense-of-microsoft-system-center-licensing/ however,you need to contact your TAM (technical account manager) or the Microsoft guy to know about your existing license and going forward, how to manage the licenses .

what is the issue if everyone has read access ? they must need read permissions else boot will fail.

yes or you can create collection with below query: select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System where SMS_R_System.Client = 0 or SMS_R_System.Client is null

is this happening across all machines or only specific ? have you added the patch to the task sequence in client installation step ? how did you set the sccm 2012 client installation task action ? something to look at http://henkhoogendoorn.blogspot.com/2011/01/task-sequence-fails-after-r3-client.html ?

You can go with 1 Primary Site at A and rest can go with Distribution Points at other locations without looking at secondary site .

Technet blog says 'we never delete any expired update associated with an active deployment, as we don’t want to remove anything associated with your deployments. It could be disconcerting if updates simply disappeared from your deployments and you had no idea why, so we just don’t do it.' it doesnt mean you should not delete the expired updates from active deployment. It depends how the organisations choose to do but i always delete the expired updates when ever i notice the updates expired to see all green color Deleting the expired updates also have impact on the packages (update to distribution points) so must look for schedule time when to remote the expired updates.

the best way to get this results is reporting. Create a SQL query to get computers missing the required patches instead of looking at collection. You have more flexibility with reports. Use the report http://eskonr.com/2015/10/sccm-configmgr-sql-query-how-to-get-list-of-patches-required-by-specific-computer/ ,modify to your needs.Patches are not like applications to check if specific patch installed or not as some patches may not be required by the client and it says Compliant (either Installed or Not applicable) so the best way is reporting to know the status (compliant,Non-Compliant and Unknown).