Windows 10: SCCM WQL Query

Good afternoon! So here is what I got going on. I am attempting to pull up a WQL query within MECM for Visio 2019, trying to see how I might be able to find out whom has access the program within the last 90 days. I am not making much progress, the only thing I believe I was able to find was if the Software was still running. Anyway, this is the query I got going so far.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 inner join SMS_G_System_Softwar

:)

 

WQL Query on SCCM Server Bitlocker - Not Updating

On our SCCM server we are running the query below to detect computers with Bitlocker not enabled. Since running this we have set bitlocker on some of the computers which from the result set, but this seems to fail when refreshing the query in SCCM. Can anyone advise on what is happening and what is required for the client to update it's status?

 

Execute a command from SCCM Task sequence step "Run a Command line"

Hi,

Thanks for your suggestion.

That will work indeed, however I need to run it from the SCCM Task Sequence's Run Command Line Step and I am not able to figure out how to do that.

Can we change line while executing command from SCCM Task Sequence's Run Command Line Step?

Regards

 

SCCM Device Collection Query

Hi All,

Many machines in my environment are not installing latest Windows Update. One of the key finding is issue with Registry.Pol Files. After investigating, we could find that few of the machines are missing registry.pol files (like they dont exits or renamed to .old ). In few machines registry.pol exits but has not updated from months although machine is online and running gpupdate /force does not make difference until registry.pol is manually deleted and recreated.

I have created a Configuration Baseline in SCCM that removes the reigistry.pol (old files) and recreates a new registry.pol file.

I need your expert advice to create a query based collection that lists out all the devices where Registry.Pol in C:\Windows\System32\GroupPolicy\Machine is missing.
If also possible another condition can be applied - if registry.pol exits what is the last modified Date and size