How to do VLOOKUP in Powershell (or at least an equivalent!)
First of all apologies for the title which is a bit click baity – it’s because I spent a lot of time googling for this and couldn’t find what I needed, that had been done…
First of all apologies for the title which is a bit click baity – it’s because I spent a lot of time googling for this and couldn’t find what I needed, that had been done…
If you added a the SCVMM server role to a VM on an existing Hyper-V cluster, then you will have been given the option to make the SCVMM server highly available as one of the…
A recent Gartner report interviewed 229 HR leaders across a range of organisations and found that half of those that responded had more than 80% of their workforce currently working remotely. They noted that over…
I recently used an XML query in Powershell that looked like this:
|
1 2 3 4 5 6 7 8 9 10 |
[cc lang="xml" escaped="true"]$xmlQuery = @' <QueryList> <Query Id="0" Path="Security"> <Select Path="Security"> *[System[(EventID=4624) and TimeCreated[timediff(@SystemTime) <= 86400000]] and EventData[Data[@Name='IPAddress'] and (Data='192.168.11.7')]] </Select> </Query> /QueryList> '@ [/cc] |
The query was used to filter events from the event log that occurred within the last 24 hours. However I needed to…
I thought I’d share a useful little powershell trick I used today which allowed me to easily compare two very similar mailboxes in Office 365. I had a user who had a duplicate mailbox which…
Client setup: Sonicwall NSA 4600 and NPS on Server 2016. Error: RADIUS Authentication Failed (MSCHAP error: E=649 R=0 V=3) Tried just about everything to fix this one. Gradually unpicked every single bit of security right…