XFS and VDO – A losing Combination
A few Bytes too many I have one volume on XFS on a VDO (Legacy) partition, this volume hosts all of my docker containers and resides on a…
Read article →Archive
Category: Uncategorized
Retro Computing
The passion of Retro Computing, combined with a love of legacy technologies. I’ve been working on a another area of the site, regarding retro computing and will have…
Read article →Fixing Cinder with LVM difficult volumes
Deleting a volume that cinder won’t delete (Error Deleting) if a volume goes into a state of error_deleting, you can still manually delete it, this is caused usually…
Read article →Welcome
Welcome to my new blog where I’ll explore aspects of corporate life, projects and products. My name is Christine Alifrangis, I am originally from the Netherlands, and have…
Read article →Convert AD Logon Time to Readable Dates
If you have added the lastLogonTimestamp field into the AD System Discovery, you can use this SQL Statement:
Read article →Get Update Compliance Status
So that one is great and all, but here’s one that presents a little more detail
Read article →Find Machines added to SCCM in the last 7 Days
select distinct (name0) ,creation_date0,datediff(day, creation_date0, {fn Now()}) as Age, CLIENT0,ad_site_name0,active0 from v_r_systemwhere (1=1)--and ad_site_name0 is null--and client0 is null--and ad_site_name0 is not nulland operating_system_name_and0 not like '%mac%'and operating_system_name_and0…
Read article →Get Count of All Machines By Platform or OS
This handly little SQL Script will get you a count of all Machines in SCCM by Operating System: select count(operating_system_name_and0 ) as Total , operating_system_name_and0 from v_r_system group…
Read article →Patches Missing or Needed By CollectionID
declare @collection varchar set @collection = ‘%’ selectCS.Name0, CS.Domain0, CS.UserName0, CS.Manufacturer0, CS.Model0, CS.NumberOfProcessors0, CS.Status0, CS.SystemType0, case when (sum(case when UCS.status=2 then 1 else 0 end))>0 then ((cast(sum(case when…
Read article →