mem-zone/sccm-zone

My ♡ collection of PowerShell scripts and SCCM related stuff :)

sccm-zone's Issues

SW-SQL_Server_Products.rdl for 2012

The SSRS report seems to be in SQL 2016 format and I am getting an error when trying to upload or open

CB Configuration Item Compliance with values bug shows only one value per computer

If the laptop have more than one drive and they all have Protection OFF, on the report it shows only the last drive it check. for ex: if c & e protection off, in the report it show E: Protection off and didnt list the c drive. did i make something wrong? . i use the second report without company information.rdl

Cleaning the SCCM Cache the right way with PowerShell

Hi loan

I hope this is the correct way to raise a query about your powershell script?

Is there a way to remove ALL non persistent data from the cache folder ?

If I run the script without parameters I do get folders deleted but I seem to get a lot of folders left over - some are persistent but most other folders have time stamps going back 3 months or more

many thanks
Mike

CB Configuration Baseline Compliance by Configuration Item with Values error due to missing database function

Hi,

This report fails to run in my enviroment due to the fact that the function 'fn_rbac_ListCIRules' is not present in my SCCM site Database. (Server 2016, SQL 2016, SCCM Current Branch v1806).

Thanks.

Conversion failed when converting value to data type

Running the report gives me:

How do I begin debugging this?

test

BitLocker

Thank you for providing a wonder full script to get the Bitlocker status.
Could you please share the script if have any where it checks and enables all the drives in the computer, whether it is OS Drive or Fixed drive, excluding CDDrive, External HDD and USB drives. And then save the recovery key to AD

SQL 2016 not in the reports

Github it is then :)

Ok, the HW collection should now have run.. but i still dont see SQL2016, i replaced all MOF and RDL files from the download page..

Any ideas ?

/Kenneth

CB Configuration Baseline Compliance by Configuration Item with Values error

Hi, thanks for the report. Report runs but it does it has problem as below.

Clean-WindowsImage image size after cleanup

Somehow the image size seems to be bigger after cleanup

Clean-CMClientCache updtaes

I tried to delete old updates. Script finished without errors, but updates are still present in CCMCACHE.