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:
Author: ChristineAli
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 .
Select Deploymentname , Available , Deadline , cast ( cast ((( cast ( [Compliant] as float ) / ( ISNULL ( [Compliant] , 0 ) + ISNULL ( [Enforcement state