Skip to content

Instantly share code, notes, and snippets.

View weeyin83's full-sized avatar

Sarah Lean weeyin83

100 followers · 33 following
View GitHub Profile
@weeyin83
weeyin83 / azure-migrate-resources.md
Last active June 10, 2020 13:44
@weeyin83
weeyin83 / azure-migrate-talk-resources.md
Created June 29, 2020 11:27
@weeyin83
weeyin83 / azure-introduction-resources.md
Last active July 6, 2020 15:09
@weeyin83
weeyin83 / hybrid-azure-resources.md
Last active July 23, 2020 11:43
Hybrid Azure Management
@weeyin83
weeyin83 / monitoring-in-azure.md
Last active August 1, 2020 12:11
Monitoring in Azure Resources
@weeyin83
weeyin83 / womenintech.md
Last active August 6, 2020 14:40
Women in Tech Talk Resources
@weeyin83
weeyin83 / choco-windows-terminal-install.sh
Created August 24, 2020 15:50
choco install microsoft-windows-terminal
@weeyin83
weeyin83 / configmgr-query.sh
Last active September 1, 2020 14:16
select distinct SMS_R_System.Name, SMS_G_System_PC_BIOS.SerialNumber, SMS_G_System_PC_BIOS.SMBIOSBIOSVersion, SMS_R_System.IPAddresses, SMS_R_System.MACAddresses from SMS_R_System inner join SMS_G_System_PC_BIOS on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId
@weeyin83
weeyin83 / configmgr-sql.sql
Last active September 1, 2020 14:24
SELECT DISTINCT SYS.Name0, IP.IP_Addresses0, NET.MACAddress0, BIOS.SMBIOSBIOSVersion0, BIOS.SerialNumber0 FROM dbo.v_RA_System_IPSubnets IPSUB INNER JOIN dbo.v_R_System SYS ON IPSUB.ResourceID = SYS.ResourceID INNER JOIN dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NETW ON SYS.ResourceID = NETW.ResourceID INNER JOIN dbo.v_GS_NETWORK_ADAPTER NET ON SYS.ResourceID = NET.ResourceID INNER JOIN dbo.v_RA_System_IPAddresses IP ON IPSUB.ResourceID = IP.ResourceID INNER JOIN dbo.v_GS_PC_BIOS BIOS on BIOS.ResourceID = SYS.ResourceID
@weeyin83
weeyin83 / configmgr-mac.sh
Created September 1, 2020 14:37
ConfigMgr Query for MAC Addresses, specific named clients
select distinct SMS_R_System.Name, SMS_R_System.MACAddresses from SMS_R_System where SMS_R_System.Name like "laptop%"