WSUS–PowerShell Reporting

Posted on February 26, 2016 by Luka

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 help to administer WSUS from PowerShell. You can read all about it on his page.

So I needed to create an scheduled report which would periodically send me the status of servers updated by WSUS. And to look nice and shiny, the report will be HTML.

 1 #Define HTML Body,table, cells
 2 $a = "<style>"
 3 $a = $a + "BODY{background-color:white;font-family: Arial; font-size: 8pt;}"
 4 $a = $a + "TABLE{border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;table-layout: fixed; width: 100%;}"
 5 $a = $a + "TH{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:white;}"
 6 $a = $a + "TD{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:white;}"
 7 $a = $a + "</style>"
 8 $a = $a + "<p style="+'"font-family: Arial;font-size: 10pt;"'+">Table Summary WSUS</p><p style="+'"font-family: Arial; font-size: 10pt;"'+">Admin</p>"
 9 
10 
11 #Sent to admin
12 $to = "admin@company.com"
13 
14 #Now Import Posh modul and connect to server
15 Import-module poshwsus
16 Connect-PoshWSUSServer -WsusServer wsusserver.company.com -port 8530 -verbose
17 
18 
19 <#
20 So, PoshWSUS has couple of scripts, and I foud out I need two, and I need them to combined
21 Get-PoshWSUSUpdateSummaryPerClient
22 and
23 Get-PoshWSUSClient
24 
25 First I get status by computer, then mor information about client itself
26 
27 #>
28 
29 
30 $Output = @() #define array to fill
31 $Computers = Get-PoshWSUSUpdateSummaryPerClient
32 
33 foreach ($Computer in $Computers)
34     {
35     $computersOstalo = Get-PoshWSUSClient $Computer.Computer
36     $grupaOstalo = Get-PoshWSUSGroup
37 
38 #save fields in array
39         $Props = @{
40       "ComputerName" = $Computer.Computer
41             "IPAddress" = $computersOstalo.IPAddress
42             "OS" = $computersOstalo.OSDescription
43             "Group" = $computersOstalo.ComputerGroup 
44       "LastUpdated" = $Computer.LastUpdated
45       "LastSyncTime" = $computersOstalo.LastSyncTime
46       "LastReportedStatusTime" = $computersOstalo.LastReportedStatusTime
47             "NeededCount" = $Computer.NeededCount
48             "FailedCount" = $Computer.FailedCount
49             "InstalledCount"=$Computer.InstalledCount
50             "PendingReboot" = $Computer.InstalledPendingRebootCount
51                         }
52    #Save every record to @output array
53     $Output += New-Object PSObject -Property $Props 
54     }
55 
56   # convert records to HTML
57 $body = $output |Select-Object ComputerName,IPAdresa,OperativniSustav,Grupa,ZadnjeUpdateirano,SinhroniziranoSaWSUS,SinhroniziranoStatusSaWSUS,PotrebnoZakrpa,NeuspjesnihZakrpa,InstaliranoZakrpaZadnjiUpdate,TrebaRestart |Sort-Object Grupa,ComputerName
58 
59 $body = $body |ConvertTo-HTML -head $a |Out-String
60 
61 #and finayl send mail to admin
62 send-mailmessage -from "WSUS Servers <wsusreports@company.com>" -to $to -subject "Report Server Summary" -bodyAsHtml -body $Body  -priority Normal -smtpServer "mailServer"

So just task scheduler this script, and you’ll have a nice report.

Good Luck

SelfService Active Directory Powershell script

Posted on October 24, 2015 by Luka

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 solution for users, that will trigger a script on mail recieve. So I searched for simillar powershell script, and I found it DeployHappiness AD Self Service Portal.
This blog show us how to send SMS to mail, but our provider does not have this kind of service.

Still, this gave me a logic of things, and how to connect ot Exhange via API on specific mailbox, and query that mailbox for specific mails.

Then I needed to make sure that only users from our Organization can request, and that the person requesting is direct or indirect manager of the user.

Example:

IT Admins
- John
  - Dave
  - Julia
    - Peter
    - Sandra
  - Steve
- Angela
  - David
  - Jeremy
    - Marco

IT admins can request Unlock or Reset for everybody
John can request Unlock or Reset for his group (Dave,Julia,Peter,Sandra), but not for himself or Angela’s group.
Angela can request Unlock or Reset for hers group (David,Jeremy,Marco), but not for herself or John’s group.
Julia can request Unlock or Reset for hers group (Peter,Sandra), but not for herself or Dave and Steve.
Jeremy can request Unlock or Reset for Marco, but not for himself or David.

(Hope you got it) Smiješak

Next on Prerequisites:

Create a user with mail adress
Create Recieve connector on Exchange for server that will host the script
On server that will host a script install Feature: Active Directory module for Window Powershell
Setup Active Directory Users Manager on Users Organization Tab (example)
Define Mail Subject and Body field (For me Subject = User for Unlock or rest, Body = what to do Unlock user or Reset password)
Create taks scheduler (run as user to which you send mail requests), triggers set to 5 minutes (more or less is up to you)

Script:
Explanations are in my script commented.

<#
Script for SelService AD
This script enables IT to unlock or reset passwords to AD users. Mangers can also request for theirs employees.
        Author: Luka Gros
        Website: blog.lukagros.com
        Email: luka@lukagros.com
        Date created: 20.Octobar.2015
        Last modified: 20.Octobar.2015
        Version: 1.1
    .LINK
        http://blog.lukagros.com
        https://twitter.com/lukagros
#>
####Parts of Script from http://deployhappiness.com/reset-user-passwords-with-ad-self-service-portal/#######
##############################################################Config##############################################################
$SmtpServer = "10.10.10.1"
$ResetEmail = "Reset Notification <reset.password@domain.com>"
$Username = "DOMAIN\user"
$Password = "Passw0rd"
$MailServer = "https://mail.domain.com/ews/exchange.asmx"
$ExchangeVersion = "Exchange2013" ##"Exchange2010_sp1"
####ALERT MAIL####################
$LoggingUser = "InformationMail@domain.com"
####NEW USER RESET PASSWORD######
$NewPassword = "Passw0rd" #You can also find function that creates random password, but we use ours default. And be careful of character length in GPO
#######Download for API assembley file is here: http://www.microsoft.com/en-us/download/details.aspx?id=35371 (There is 2.2 that works better with Exchange 2013)
[Reflection.Assembly]::LoadFile("C:\Program Files\Microsoft\Exchange\Web Services\2.2\Microsoft.Exchange.WebServices.dll")
##############################################################Config##############################################################
###############################Function that checks if requester is manager to user###############################
#######http://www.lazywinadmin.com/2014/10/powershell-who-reports-to-whom-active.html########
function Get-ADdirectReports
{
    PARAM ($SamAccountName)
    Get-Aduser -identity $SamAccountName -Properties directreports | %{
        $_.directreports | ForEach-Object -Process {
            # Output the current Object information
            Get-ADUser -identity $Psitem -Properties mail,manager | Select-Object -Property Name, SamAccountName, Mail, @{ L = "Manager"; E = { (Get-Aduser -iden $psitem.manager).samaccountname } }
            # Find the DirectReports of the current item ($PSItem / $_)
            Get-ADdirectReports -SamAccountName $PSItem
        }
    }
}#CLOSE SECTION function Get-ADdirectReports
###############################Connect to Exchange mailbox###############################
 $email = New-Object Microsoft.Exchange.WebServices.Data.ExchangeService([Microsoft.Exchange.WebServices.Data.ExchangeVersion]::Exchange2013)
 $email.Credentials = New-Object Net.NetworkCredential($Username, $Password)
 $uri=[system.URI] $MailServer
 $email.Url = $uri
 $inbox = [Microsoft.Exchange.WebServices.Data.Folder]::Bind($email,[Microsoft.Exchange.WebServices.Data.WellKnownFolderName]::Inbox)
###############################Connect to Exchange mailbox###############################
###############################Check if there are unread mails###############################
if ($inbox.UnreadCount -gt 0)
 {
        $PropertySet = new-object Microsoft.Exchange.WebServices.Data.PropertySet([Microsoft.Exchange.WebServices.Data.BasePropertySet]::FirstClassProperties)
        $PropertySet.RequestedBodyType = [Microsoft.Exchange.WebServices.Data.BodyType]::Text;
        # Set search criteria - unread only
        $SearchForUnRead = New-object Microsoft.Exchange.WebServices.Data.SearchFilter+IsEqualTo([Microsoft.Exchange.WebServices.Data.EmailMessageSchema]::IsRead, $false)
        $items = $inbox.FindItems($SearchForUnRead,10)  #return only 10 unread mail items
        Import-Module -Name ActiveDirectory
 ###############################CHECK IF UNREAD ITEMS - IF NOT END###############################
 foreach ($item in $items.Items)
 {
  # load the property set to allow us to view the body
 $item.load($PropertySet)
    #######Get Subject and Body fields###
        $getsubjecttext = $item.subject
        $getsubjecttext = $getsubjecttext+"*" #add right wildcard
        $getbodytext = $item.body
        $getsubjectuser = Get-ADUser -Filter {DisplayName -like $getsubjecttext -and employeetype -eq'1'} -Properties UserPrincipalName,SamAccountName,cn,DisplayName,mail
        If ($getsubjectuser -eq $null) #If IT cannot be found by full name, try by SamAccountName
            {
            $getsubjectuser = Get-ADUser -Filter {SamAccountName -like $getsubjecttext -and employeetype -eq'1'} -Properties UserPrincipalName,SamAccountName,cn,DisplayName,mail
            }
        $managerEmployeOK = '0' ##Reset Manager Flag
        #######Get-requestere###
        $address = $item.From.address
        $user = Get-ADUser -Filter {UserPrincipalName -eq $address} -Properties UserPrincipalName,SamAccountName,cn
  ###Reset Unlock nad Reset flags for every mail####
  $UnlockAccount = '0'
  $ResetpwdAccount = '0'
#######IF Keywords in body
  if (($item.body.text -Like "Unlock account*") -and $getsubjectuser -ne $null) #THIS IS STRICT OR PEOPLE WILL WRITE RUBBISH
        {
            $UnlockAccount = '1'
        }
  if ($item.body.text -Like "Reset Password" -and $getsubjectuser -ne $null -and $UnlockAccount -eq '0') #THIS IS STRICT OR PEOPLE WILL WRITE RUBBISH
        {
            $ResetpwdAccount = '1'
        }
#################################If requester is found GO - IF NOT do nothing#######################################
if($user -ne $null)
{
<# If user is under requester set flag $managerEmployeOK=1, if not send mail NO RIGHTS
#>
    $usersToDo = Get-ADDirectReports $user.SamAccountName
    foreach ($Name in $usersToDo)
    {
        if ($Name.SamAccountName -eq $getsubjectuser.SamAccountName)
            {
                #Write-Output $Name.SamAccountName
                $managerEmployeOK = '1'
            }
    }
####Allow IT admins######
If ($user.SamAccountName -eq 'userAdmin1' -or $user.SamAccountName -eq 'userAdmin2') ##You can write if userAdmin is in some AdminGroup that can send requests
    {
    $managerEmployeOK = '1'
    }
##################################
IF ($managerEmployeOK -eq 1)
{
###UNLOCK SECTION################################################################################
 if($UnlockAccount -eq '1')
    {
            ##The line below is commented for e-mail testing, no command is issued
            ###Unlock-ADAccount -identity $getsubjectuser.samaccountname
            ##Send MAIL TO $LoggingUser = "InformationMail@domain.com"###################################
            $body="
                <p style='font-family:arial'>User Account " + $getsubjectuser.cn + " (" + $getsubjectuser.SamAccountName + ") has been unlocked. Request was from: $address</p>
                <p>&nbsp;
                <p style='font-family:arial;font-size:12px;color:red'>Please do not respond to this automatic e-mail!</p>
                "
            send-mailmessage -to $LoggingUser -from $ResetEmail -subject "Action: User unlock requested!" -body $Body  -SmtpServer $SmtpServer -BodyAsHtml -Encoding UTF8
            ##Send MAIL TO Requester###################################
            $body="
                <p style='font-family:arial'>HI,</p>
                <p style='font-family:arial'>User " + $getsubjectuser.cn + " (" + $getsubjectuser.SamAccountName + ") has been unlocked.</p>
                <p>&nbsp;
                 <p style='font-family:arial;font-size:12px;color:red'>Please do not respond to this automatic e-mail!</p>
                "
            send-mailmessage -to $item.From.address -from $ResetEmail -subject "User is unlocked!" -body $Body -SmtpServer $SmtpServer -BodyAsHtml -Encoding UTF8
            ##SEND MAIL TO unlocked user###################################
                $body="
                <p style='font-family:arial'>Hi " + $getsubjectuser.cn + ",</p>
                <p style='font-family:arial'>User " + $user.cn + " (" + $item.From.address + ") has requested unlocking of your account.</p>
                <p style='font-family:arial'>Your account <b>" + $getsubjectuser.SamAccountName +"</b> is now unlocked</p>
                <p>&nbsp;
                 <p style='font-family:arial;font-size:12px;color:red'>Please do not respond to this automatic e-mail!</p>
                "
            send-mailmessage -to $getsubjectuser.mail -from $ResetEmail -subject "Your account has been unlocked!" -body $body -SmtpServer $SmtpServer -BodyAsHtml -Encoding UTF8
            $Unlock = $True
    }#UNLOCK CLOSE SECTION
###RESET SECTION################################################################################
 if($ResetpwdAccount -eq '1')
    {
                <#The line below is commented for e-mail testing, no command is issued
                ###Set-ADAccountPassword -identity $user.samaccountname -Reset -NewPassword (ConvertTo-SecureString -AsPlainText $NewPassword -Force) #Set users new password
                ###Unlock-ADAccount -identity $user.samaccountname #Probably user locked, so unlock
###Set-ADUser -Identity $user.samaccountname -ChangePasswordAtLogon $true #Set must change password on next logon
                #>
                ##If the password was reseted in the last 10 minutes do nothing
                $PasswordAge = (Get-ADUser $getsubjectuser -Properties PasswordLastSet | Select PasswordLastSet)
                if ((Get-Date).AddMinutes(-10) -ge $PasswordAge.PasswordLastSet)
                 {
                ##Send MAIL TO $LoggingUser = "InformationMail@domain.com"###################################
                    $body="
                        <p style='font-family:arial'>Request for password reset for user " + $getsubjectuser.cn + " (" + $getsubjectuser.SamAccountName + "). Request was from: $address</p>
                        <p>&nbsp;
                        <p style='font-family:arial;font-size:12px;color:red'>Please do not respond to this automatic e-mail!</p>
                      "
                    send-mailmessage -to $LoggingUser -from $ResetEmail -subject "Action: User password reset requested!" -body $Body  -SmtpServer $SmtpServer -BodyAsHtml -Encoding UTF8
                    ##Send MAIL TO Requester###################################
                    $body="
                        <p style='font-family:arial'>Hi,</p>
                        <p style='font-family:arial'>Password reset for user" + $getsubjectuser.cn + " (" + $getsubjectuser.SamAccountName + ").</p>
                        <p style='font-family:arial'>New password is : <b>" + $NewPassword + "</b></p> ##If user cannot read their mail, then their manager can let them now
                        <p style='font-family:arial'>User can now try to logon with his/hers new password, but password must be changed on first logon!</p>
                        <p>&nbsp;
                        <p style='font-family:arial;font-size:12px;color:red'>Please do not respond to this automatic e-mail!</p>
                        "
                    send-mailmessage -to $item.From.address -from $ResetEmail -subject "Reset user password complete!" -body $Body -SmtpServer $SmtpServer -BodyAsHtml -Encoding UTF8
                    ##SEND MAIL TO user###################################
                    $body="
                        <p style='font-family:arial'>Hi " + $getsubjectuser.cn + ",</p>
                        <p style='font-family:arial'>User " + $user.cn + " (" + $item.From.address + ") requested your password to be changed. Your new password is: <b>" + $NewPassword +"</b></p>
                        <p>&nbsp;
                        <p style='font-family:arial;font-size:12px;color:red'>Please do not respond to this automatic e-mail!</p>
                           "
                    send-mailmessage -to $getsubjectuser.mail -from $ResetEmail -subject "Your password has been reseted!" -body $body -SmtpServer $SmtpServer -BodyAsHtml -Encoding UTF8
                } #CLOSE SECTION when was password last set
    }#CLOSE RESET SECITON
 ###Command or user unknown################################################################################
 if (($UnlockAccount -eq '0' -and $ResetpwdAccount -eq '0') -or ($getsubjectuser -eq $null))
    {
                        ##Send MAIL TO $LoggingUser = "InformationMail@domain.com"###################################
                        $body="
                        <p style='font-family:arial'>There was request " + $getsubjecttext +"; with body " + $getbodytext +"</p>
                        <p style='font-family:arial'>Request was  from: $address</p>
                        <p>&nbsp;
                        <p style='font-family:arial;font-size:12px;color:red'>Please do not respond to this automatic e-mail!</p>
                        "
                        send-mailmessage -to $LoggingUser -from $ResetEmail -subject "Action:request error" -body $Body  -SmtpServer $SmtpServer -BodyAsHtml -Encoding UTF8
                        ##Send MAIL TO Requester###################################
                        ##Don't forget here to write the instructions how the mail was supose to look
                        $body ="
                        <p style='font-family:arial'>Hi " + $user.cn + ",</p>
                        <p style='font-family:arial'>YOur mail, with title <b>" + $item.subject + "</b> is unknown.</p>
                        <p style='font-family:arial'>Please write correct user FirsName and Surname, or loginname.</p>
                        <p style='font-family:arial'>Keywords:</p>
                        <ul style='font-family:arial'>
                        <li><b>Unlock</b> - unlocks</li>
                        <li><b>Reset</b> - password reset</li>
                        </ul>
                        <p>&nbsp;
                        <p style='font-family:arial;font-size:12px;color:red'>Please do not respond to this automatic e-mail!</p>
                        "
                        send-mailmessage -to $item.From.address -from $ResetEmail -subject "Mail command unknown" -body $Body -SmtpServer $SmtpServer -BodyAsHtml -Encoding UTF8
      }#CLOSE SECTION Command or user unknown
} #CLOSE SECTION managerEmployeOK
else #If not manager
{
                        ##Send MAIL TO $LoggingUser = "InformationMail@domain.com"###################################
                        $body="
                        <p style='font-family:arial'>Stigao je mail sa naslovom <b>" + $getsubjecttext +"</b></p>
                        <p style='font-family:arial'>i tekstom <b>" + $getbodytext +"</b></p>
                        <p style='font-family:arial'>Zahtjev je došao sa adrese: $address</p>
                        <p>&nbsp;
                        <p style='font-family:arial;font-size:12px;color:red'>Please do not respond to this automatic e-mail!</p>
                        "
                        send-mailmessage -to $LoggingUser -from $ResetEmail -subject "Action:manager error" -body $Body  -SmtpServer $SmtpServer -BodyAsHtml -Encoding UTF8
                        ##Send MAIL TO Requester###################################
                        $body ="
                        <p style='font-family:arial'>Hi " + $user.cn + ",</p>
                        <p style='font-family:arial'>According to our specifications, you are not manager to user " + $getsubjectuser.cn + " (" + $getsubjectuser.SamAccountName + "). </p>
                        <p style='font-family:arial'>Request denied!</p>
                        <p>&nbsp;
                        <p style='font-family:arial;font-size:12px;color:red'>Please do not respond to this automatic e-mail!</p>
                        "
                        send-mailmessage -to $item.From.address -from $ResetEmail -subject "Manager request error" -body $Body -SmtpServer $SmtpServer -BodyAsHtml -Encoding UTF8
}#CLOSE SECTION if not manager
##Set mail read
$item.Isread = $true
$item.Update([Microsoft.Exchange.WebServices.Data.ConflictResolutionMode]::AlwaysOverwrite)
 }#CLOSE SECTION Requester OK
 } #CLOSE SECTION foreach ($item in $items.Items)
 } #CLOSE SECTION ($inbox.UnreadCount -gt 0)

So , this would be it.

RUN programs as NT Authority\System

Posted on March 2, 2015 by Luka

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 PsTools – PsExec.

So, the procedure is as follows:

Run CMD as Administrator
psexec -i -s cmd.exe

Go to the folder where the file reports Access Denied:

After that, take ownership of the file with:
takeown /R /F *

And reset permissions with icalcs:
icacls * /T /Q /C /RESET

So this is how I solved my Access Denied on File problem.

Good Luck

How To remotely manage IIS from Client Computers

Posted on December 29, 2014 by Luka

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 of all when installing IIS on the server, also check Management Service

When Installed

open IIS console, navigate to Management Service and open it.

Check Enable remote connections
If you plan to have local IIS managers, check Windows credentials or IIS Manager credentials
If you plan to manage IIS only with domain users, then check Windows credentials only

Leave IP address All Unassigned with manage port 8172 (IF YOU HAVE FIREWALL ENABLED, YOU MUST CREATE INBOUND RULE FOR THE PORT 8172)
For SSL certificate choose Server certificate (FQDN of the server)

And for more security, you can configure if you want to allow or deny some IP address on your LAN or WAN network. Depends from where are you planning to mange IIS.

When you completed the configuration, on the right side, press Apply ,and then Start.
One more step is to allow users to remotely connect to IIS server. Open IIS Manager Users.

For remote local admin users on IIS
On the right side press Add User.
User name: username
Password: Password from domain

This was configuration on the server, for more servers, repeat these steps on all of them. If you have NLB, you must do this on all of them!

Now, on the client side:
Go to Add Programs and Features and click on Turn Windows Features on or off

Click under Internet Information Services – Web Management Tools – IIS Management Console

After installation, download IIS Manager for Remote Administration 1.2, this gives you option to connect to remote server or site.

After installation, open your local IIS Manager, and connect to remote server:

Username must be entered with @domain.com suffix, or else it will return an error Unauthorised.
Enter domain password for that user.

Enter the name of connection

When done, you will have a list of remotely managed IIS servers.

Good Luck

Pair your PC or Notebook with YouTube on smart TV

Posted on March 8, 2014 by Luka

I have an IPhone, and when I watch YouTube on it, I can stream the video directly to my Smart TV. Since playing YouTube videos directly on Smart TV YouTube app is unpractical, I wondered If I could connect my Laptop with my Smart TV.
And I did it with a help of Google Chrome. I knew that Google Chrome has developer option, in which you can set the rendering of the web page for some mobile and tablet devices.

So in Google Chrome go to Tools – Developer Tools.

press

Press Emulate

Restart Chrome, open YouTube and in the upper right corner of video press Stream to TV.

Good Luck

Active Directory User Auditing – SCOM 2012

Posted on March 7, 2014 by Luka

In my last chapter I was talking about User AD account audit with power shell scripting and Task Scheduler. I also provided an list of Event IDs.
This time I will show you how to create those notification through System Center Operations Manager.

In OM Console open Authoring,

the next thing is to go to rules and create new one.

These events are Security Events in NT Events, so we choose Alert Generating Rules, then Event Based, then NT Event Log

/*************/
My suggestion is to create an Custom AD User Events Management pack in which to store those rules. It is easier to edit, or change some things if you have your own packs.

/***********/

Now select Default Management Pack, or newly created AD Custom Pack,

After this, name your Rule, set Category and target.
Targets are Domain Controllers, which you defined when

Next, set logon type as security, because it is a security based rule.

Create expression for Event ID 4740 from Security Auditing

On the next screen, you have an option the design your own alert description, with Priority and Severity. I suggest you set for locked account to Low Warning.
Now in description you have an option to use already configured placeholders, or you can create your own.

When you create it, then you can test it by locking some account.

As you see, I have two Domain controllers, and account is locked on both, which is ok, since the DCs are synced.

Now you can create these rules for all the event IDs you like.

Good Luck

Active Directory User Auditing – Simple

Posted on March 6, 2014 by Luka

For my Audit report, I had to create an audit list about creating,deleting,disabling,enabling,locking, unlocking my AD users.

Since we haven’t had a SCOM on our premises, I hade to come up with something that will trigger an e-mail to me with an event.
First of all you have to enable user auditing on Default GPO.

After that, I connected to my primary domain controller and created an Powershell script (with a little help from http://powershell.com/cs/) which sends an e-mail in HTML form to me, with some parameters.
First of all, it creates HTML file with a table, which then populates from Security Event under Event ID 4740. After it populates HTML file, this table sets as an body, and sends it to email addresses.

#$DC = "DCServerName"    2: $Report= "C:\Admin\lockedaccount\locked.html" 
$HTML=@" 
<title>Account locked out Report</title> 
<style> 
BODY{background-color :#FFFFF} 
TABLE{Border-width:thin;border-style: solid;border-color:Black;border-collapse: collapse;} 
TH{border-width: 1px;padding: 1px;border-style: solid;border-color: black;background-color: ThreeDShadow} 
TD{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color: Transparent} 
H2{color: #457dcf;font-family: Arial, Helvetica, sans-serif;font-size: medium; margin-left: 40px; 
</style> 
"@ 
$Account_Name = @{n='Account name';e={$_.ReplacementStrings[-1]}} 
$Account_domain = @{n='Account Domain';e={$_.ReplacementStrings[-2]}} 
$Caller_Computer_Name = @{n='Caller Computer Name';e={$_.ReplacementStrings[-1]}} 
$event= Get-EventLog -LogName Security -ComputerName $DC -InstanceId 4740 -Newest 1 | 
   Select TimeGenerated,ReplacementStrings,"Account name","Account Domain","Caller Computer Name" | 
   % { 
     New-Object PSObject -Property @{ 
      "Account name" = $_.ReplacementStrings[-7] 
      "Account Domain" = $_.ReplacementStrings[5] 
      "Caller Computer Name" = $_.ReplacementStrings[1] 
      Date = $_.TimeGenerated 
    } 
   } 
  $event | ConvertTo-Html -Property "Account name","Account Domain","Caller Computer Name",Date -head $HTML -body  "<H2> User is locked in the Active Directory</H2>"| 
     Out-File $Report -Append 
$MailBody= Get-Content $Report 
$MailSubject= "User Account locked out" 
$SmtpClient = New-Object system.net.mail.smtpClient 
$SmtpClient.host = "mail.uniqa.hr" 
$MailMessage = New-Object system.net.mail.mailmessage 
$MailMessage.from = “AccountLockout@test.com” 
$MailMessage.To.add(“itsupport@test.com”) 
$MailMessage.Subject = $MailSubject 
$MailMessage.IsBodyHtml = 1 
$MailMessage.Body = $MailBody 
$SmtpClient.Send($MailMessage) 
del C:\Admin\lockedaccount\locked.html 

After creating this powershell script, the next step is to create an Event Trigger which will send this e-mail.
This is done through Task Scheduler.

This trigger works when Event with 4740 ID is generated in Security Event Viewer.

-command "& 'C:\Admin\lockedaccount\account_locked_out.ps1' "

The final result is this:

Now, you can do this with Unlock account 4767, or Disable account 4725 or deleted 4726etc.
I found out this site with lists of Event IDs : link

Good Luck

Windows Server NIC address error

Posted on October 2, 2013 by Luka

We virtualized one of our servers with VMM2012 P2V. Conversion went like a charm, but there was some IP problems.
So, the VMM2012 converted NIC adapters, but he transferred addresses to Hyper-V Virtual Network adapter, because his physical adapters are no longer present.
The server was up and running in virtual environment, but I hade to make some modifications to NIC.
then I received an error:

“The IP address X.X.X.X you have entered for this network adapter is already assigned to another adapter……”

So that means that no longer present adapter has the same address as the new virtual one.
Now, first of all we must go to device manager, but we must be able to see also nonpresnet adapters.
Open CMD as admin on that machine:
set devmgr_show_nonpresnet_devices=1
start devmgmt.msc

On View menu select Show hidden devices.

Expand Network adapters, and uninstall old/no presented adapters.

I suggest restart the machine

Good Luck

Server – prevent registration of multiple IP to DNS from one server

Posted on May 30, 2013 by Luka

I have a server with two IP addresses, one for internal network, one for external. But my server registers both IP addresses to DNS, and computers on internal network, sometimes get connection timeout.
The problem was solved when I disabled the DNS registration on the other NIC.

Go to TCP/IP v4 properties on NIC

Hit button Advanced

In DNS tab remove check mark on Register this connection’s addresses in DNS

now delete the A record, from DNS, with secondary IP and flushdns on computer with connection problem.

Good Luck

Uninistall of SC agents from Core OS

Posted on May 10, 2013 by Luka

I deinstalled VMM 2012 from one server. But its agents remained on my Hyper-V core installation servers. How to uninstall them if no Add/Remove programs exist, or you dont have original agent.msi package?

On Core OS (2008 or 2012) run regedit
Go to HKLM\Software\Microsoft\Windows\Current Version\Uninstall
Expand Uninstall, then search in subfolders for string in DisplayName =”System Center Virtual Machine Manager Agent (x64)”, then you know this is a folder for VMM agent.
Now from that same folder copy entire string (example: MsiExec.exe /I{5142AB0B-73E3-4AD3-9D0F-65B3D9026769}) from UninstallString to CMD window in CoreOS and press Enter.

Good Luck