When I saw the code Getting All the Information of the Server in SQL Server – MSSQL Query, I thought to share mine.This more or less sums the general MS SQL instance information Good Luck
When I saw the code Getting All the Information of the Server in SQL Server – MSSQL Query, I thought to share mine.This more or less sums the general MS SQL instance information Good Luck
When I saw the code Getting All the Information of the Server in SQL Server – MSSQL Query, I thought to share mine.This more or less sums the general MS SQL instance information Good Luck
I my last post, I mentioned that sometimes I need to create some reports and send it via e-mail. In this situation I like to use Powershell and format it into HTML.When you send object via email, you can customize the sending format. I’ll stick to very knowable Get-Service command The output of this e-mail …
For some time I’ve been coding in Powershell. This post is intendent as my little cheat sheet. Multiline Code When writing Powershell code this string ` could be your friend when nicely formatting the code Get-EventLog – Parsing messages We have some event logging on servers Event Log. Sometimes I have to go through them …
When you want to keep track on how yours runbooks run, you can always get a select from Orchestrator database. From this point, you can create Runbook, which will check error events in the last hour. After you use Query Database, it is time to manipulet string with Powershell. Don’t forget to publish data, so …
In our organization, we have SCCM for manual update deployment. I have a lot of servers I need to patch, on some regular basis. Most of my servers reside on VmWare infrastructure, and before every update I need to create a snapshot of each and every one.With the help of Powershell scripts and VmWare PowerCli …
Hi, Today I noticed one service that was hanged in Starting state. Through GUI I could not stop it or start it. Since I got PID (process ID) from my query, I can kill the process Now the process has been killed, we can start it once again withnet start <ServiceName> Good Luck
Every couple of months, I need to check Windows firewall on some secure/crucial Windows servers. I needed a automatic report that I can go through quickly. I used powershell, which goes through firewall rules, and in the end it creates an simple HTML report. Parts of code were used from Spiceworks Community In the end, …
Continuing on couple of my previos Lotus Notes and Powershell (pt1,pt2) posts.. Our Lotus Notes isn’t connected to AD, so everything must be done separately from AD. Users, groups, ACL, and so on. Couple of days ago, I had an request that one mail group in Lotus must be identical to one AD group. So, …
To continue my journey (PS and LN pt1) in PS scripting on Lotus Notes, I wanted to see if it is possible to manipulate groups members in LN. Well, it is possible, and I will show you how I did it. As you remeber from my last post, If you want to connect to Lotus Notes …