Our SCCM DB is on an AAG. When it fails over to one node we get the error:  An error occurred in the Microsoft .NET Framework while trying to load assembly id 65541. The server may be running out of resources, or the assembly may not be trusted. Run the query again, or check documentation to see how to solve the assembly trust issues. For more information about this error:   System.IO.FileLoadException: Could not load file or assembly 'smssqlclr, Version=5.0.0.0.... when we set trustwo

I need to create a Collection based on Model and BIOS version above 1.7   I try following query but it doesnt show any machine. I have check few machine and I can see that BIOS version is 1.6.x select distinct 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 inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System

I am trying to build a collection based on the Last Online time (within an arbitrary number of days). I know typically this is done using the Heartbeat, ClientActivity, or Hardware scan property. but I would like to see all machines, to identify which machines may not have the client installed.  I cant for the life of me find where the column in the collections view populates from.  I have the queries to filter out machines based on Last Hardware Scan shown below. I am looking for some

Which process is running under an OS deployment? I'm running a ScheduledTask, witch cannot run when the user is updating the OS. Is this TSManager.exe, eller does this process runs more often ?

I have a model laptop Dell Latitude 5510 that's unable to join the domain. "Failed to join domain. The account may not have permission The specified domain either does not exist or could not be contacted. (Error: 8007054B; Source: Windows)'' Checked the permissin forthe account to join the domain. All is fine. Only a few of my new machines hare having this issue. Running osdjoin.exe     OSDJoin    2021/02/10 11:22:01    3200 (0x0C80) Running module version 5.0.9012.1000 from

Hi Guys,   Thanks for accepting and offering this website for IT tech to solve some issues. I have an issue with AppV, every time I try to create an Appv I got this error/message and stop me form complete the process.any help will appreciate

Is there a way to delete a machine from ad and sccm before or during a TS? We want to do this because it's still linked to collections with app deployments the end-user doesn't need/want.

Hello to all,                   so we currently have an SCCM setup which has the DP on one server and a separate SQL server ; all is running fine, however I am noticing the below errors when monitoring compmon.log ; Failed to read the required Operations Management component (SMS_SITE_SQL_BACKUP_) registry key values on local computer; error = 6 (0x6). I checked this using procmon and also noticed the below issues. The Performance folder cannot be found and in actual fact it is