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
DNS management Windows 10 1709
Recentley I discovered that DNS management is not installed when installing RSAT (WindowsTH-RSAT_WS_1709-x64) to Windows 10 1709 (Fall Creators Update). After trying to install RSAT for Windows Server 2016, it was still missing. So I turned to Technet and I found a article (here). The thing is that you have to download the following files …
WinRM problems
Couple of days ago, I installed new version of Project Honolulu. I added few serves, but one of them reported error connecting. Error reported WinRM connection failed. So I tested it with PowerShell Test-WSMan –ComputerName SERVER01.corp.loc And yes, there was an error:Test-WSMan : <f:WSManFault xmlns:f=”http://schemas.microsoft.com/wbem/wsman/1/wsmanfault” Code=”2150858770″ Machine=”SOURCEPC.corp.loc”><f:Message>The client cannot connect to the destination specified in …
Active Directory Logon Script
Hi, for some time now we used batch script to log user logon to theirs domain computers. What we collected via this script was something like this: Mon 02.01.2017., 7:55:06,64,user1,AD-PC1,Windows 7 or Server 2008R2,32 Bit Mon 02.01.2017., 7:55:42,90,user2,AD-PC2,Windows 7 or Server 2008R2,64 Bit Mon 02.01.2017., 7:55:46,51,user3,AD-PC3,Windows 7 or Server 2008R2,32 Bit Mon 02.01.2017., 7:55:50,94,user4,AD-PC4,Windows 7 …
Managing DNS in Workgroup
So, we are migrating our external DNS servers to another IP pool. SO I had to create a DNS server (later two), which will be on new IP pool, so we can remove the old ones. I used Microsoft Windows Server 2016 Core version for this. No excessive updates, GUIs or problems. But, since it …
Hide DNS Version
Some time ago, I’ve setup internal (AD based) DNS and external DNS for our domain. Now, when you do domain checkup with BIND tools, you will usualy get DNS version. For my external DNS it reported it was Windows server DNS. Now, for that problem (security issues), I found a solution on: http://www.admin-enclave.com/en/solutions/windows/146-hide-microsoft-dns-software-version.html I is …
Windows 10 start menu search problem
Hi, when Windows 10 came out, I bravely installed it on my business notebook. It works great, except Start menu search. Everything I searched returned blank. So I got couple of days to check what was going on. I tried repairing Windows with SFC, I tried turning off Cortana, tamper with registry.. but nothing worked. …
WSUS–PowerShell Reporting
Hi, So, since it took me a while to understand that you cannot get scheduled reports from WSUS 3.0, I had a quest to create my own. I searched through SQL database, and WSUS public Views and procedures, but it was time expensive. Then I stumbled upon PoshWSUS scripts (here). Boeprox created PowerShell scripts, which …
SelfService Active Directory Powershell script
Hi everybody, We have a need for self service portal in our IT department. We arranged after work shifts, and if I’m not near my VPN connected PC, I needed to unlock or reset user passwords, or give users the ability to have their mangers do that for them. I needed unlock or password reset …
RUN programs as NT Authority\System
I had little trouble, a while back, where I lost permission on a file as an administrator.When I search for it, I got several codes how to take ownership and reset permission.But, It cannot be done as simply as Run As Administrator.I had to start CMD as SYSTEM account. For this I used part of …
How To remotely manage IIS from Client Computers
Several months ago we had one IIS server, and connecting to it over RDP was not a problem. But now, since we got 4 IIS server on F5 NLB, Its quite problematic to connect to 4 IIS servers over RDP. So I managed to install IIS administration, and I’m about to show you how. First …