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 easier for
Posts
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 different reasons:
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 lived in
If you have added the lastLogonTimestamp field into the AD System Discovery, you can use this SQL Statement:
Query to determine machines less than a PentiumÂ
So that one is great and all, but here’s one that presents a little more detail
select distinct ( name0 ) , creation_date0 , datediff ( day , creation_date0 , { fn Now ()}) as Age , CLIENT0 , ad_site_name0 , active0 from v_r_system where (
select distinct ServerName , vss . percentfree , vss . status , dp . sitecode , dp . bitsenabled , vss . DownSince , vss . TimeReported from vSummarizer_SiteSystem as
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
declare @collection varchar set @collection = ‘%’ select CS . Name0 , CS . Domain0 , CS . UserName0 , CS . Manufacturer0 , CS . Model0 , CS .