uploadImage to Glance
One of the more tedious constant tasks in Openstack, especially if you’re using CI/CD, is to update images. Here’s a little script to make this just a little…
Read article →Latest writing
Posts
Deleting failed volume attachments in Openstack
This bash script will delete failed volume attachments / volumes from a stack in Openstack. Why? Sometimes Heat can fail to delete a stack for a variety of…
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 →Determine machines less than a Pentium IV
Query to determine machines less than a Pentium
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 →Determine which Distribution Points are Offline
select distinct ServerName,vss.percentfree, vss.status, dp.sitecode, dp.bitsenabled, vss.DownSince,vss.TimeReported from vSummarizer_SiteSystem as vss left join v_DistributionPointInfo as dp on vss.SiteSystem = dp.NALPath where vss.role = 'SMS Distribution Point' and vss.status…
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 →