Category Microsoft

02/10/2018

If Not Exists – Batch Script

By Steve in Batch Scripts and PowerShell, Microsoft, Microsoft Windows Server 2008, Microsoft Windows Server 2012 Tag Batc, IfNot

Create a batch file to check a text file is in the location specified, else run a task. #This batch file checks to see if a text file is…

02/10/2018

Files Older Than 3 Months Combined Total File Size

By Steve in Microsoft, Microsoft Server 2016, Microsoft Windows Server 2012, Powershell Tag file sizes, lastwritetime

A requirement to identify the total file size of all files not used in the last 3 months. This was the solution #Run as administrator #You need to have permission…

20/09/2018

vSphere ESXi 6.7 Unable to talk between subnets between hosts

By Steve in ASA, CISCO, ESXi, ESXi 6.7, Microsoft, Microsoft Server 2016, VMware Tag 6.7, ASA, CISCO, Code 0, Denied ICMP, ESXi, Firewall, interfaces, Port Groups, Security Levels, Type 8, VLANS, VMware, vSphere

Configuration was : ESXi 6.7 - vSphere handling all the port groups tagged with VLANs Firewall - CISCO ASA Problem : New ESXi 6.7 hosts. A virtual machine if…

11/09/2018

Task : Output A List Of Home Drive Paths Configured In Active Directory

By Steve in Active Directory, DS Commands, Microsoft, Microsoft Server 2016, Microsoft Windows Server 2012, Powershell Tag Active Directory, CSV EXPORT, DSQUERY, Get-ADUser, HOME DRIVE, PowerShell, USER PROPERTIES

#DSQuery dsquery user -name "*" -limit 0 | dsget user -samid -hmdir -hmdrv -profile >c:\temp\usersV2.txt #PowerShell # More flexibility # Includes the state of the computer account (Enable or…

11/09/2018

How To Access A SQL Server 2008 Databases WITHOUT SA (SysAdmin) Credentials

By Steve in Ethical Hacking, Microsoft, Microsoft SQL Server 2008, Microsoft Windows Server 2008 Tag Ethical Hacking, PSEXEC, SA, SQL, SQL 2008, SSMS, SysAdmin

Challenge : How to make a backup of a SQL 2008 database without knowing any working credentials. Log on to the Windows 2008 R2 server running SQL Server 2008 as…

10/09/2018

Remove Directory Batch Script

By Steve in Batch Scripts and PowerShell, Microsoft Tag BATCH, RMDIR

#Remove directory in a batch file # rmdir /S /Q "C:\test\"

14/08/2018

Robocopy Mirror Files and Folders

By Steve in Batch Scripts and PowerShell, Microsoft, Microsoft Server 2016, Microsoft Windows 10 Tag /Mir, Mirror, Robocopy

Map network drives to the correct locations Run CMD as Administrator Mirror file & directories and output detail to text file robocopy E:\..... z:\.... /MIR /S >c:\temp\detail.txt

14/08/2018

List all users in the domain and email addresses

By Steve in Microsoft, Microsoft Server 2016, Microsoft Windows 10, Powershell Tag Active Directory, export-csv, Get-ADUser, List Email Addresses, List Users, PowerShell

import-module activedirectory #List all users in the domain # Display Name and Email Address get-aduser -Filter * -SearchBase "dc=Test,dc=com" -Properties Displayname,emailaddress | select displayname ,emailaddress | Export-Csv C:\temp\users_and_email.csv

13/08/2018

Troubleshooting Windows Updates and WSUS

By Steve in Microsoft, Microsoft Server 2016, Microsoft Windows 10, Powershell Tag Get-WindowsUpdateLog, Troubleshooting, Windows 10, Windows Updates

Troubleshooting Windows Updates #Windows 10 #Windows 2016 Windows Update Log PowerShell command to check the Windows Update log • Get-WindowsUpdateLog Check Registry Keys Run command prompt as adminitrator and…

13/08/2018

Get a list of active users which have logged on to the domain in the last 7 days

By Steve in Microsoft, Microsoft Server 2016, Microsoft Windows 10, Microsoft Windows Server 2008, Microsoft Windows Server 2012, Powershell Tag Active Directory, Get-ADUser, Get-Date, LastLogonDate, PowerShell

# Get a list of users which have logged on to the domain in the last 7 days $Date = (Get-Date).AddDays(-7) Get-ADUser -Filter {LastLogonDate -gt $Date} | Select distinguishedName