Wednesday, 14 June 2017

List all SIDs

need to run this using admin privileges via windows PowerShell cmd

Get-ADUser -Filter * -SearchBase "ou=Sales,ou=West,dc=MyDomain,dc=com" |  Select sAMAccountName, SID

ex: Get-ADUser -Filter * -SearchBase "ou=users,ou=department,dc=yourdomain,dc=com" |  Select sAMAccountName, SID

How to send Node to Node Message in Windows 7 Connected Nodes

by default this feature has been deprecated in Windows 7
however, a domain admin with domain privileges can do so from command prompt

syntax:

msg /server:L1411004 console testmsg

where L1411004 is the hostname and testmsg is the actual message

If you encounter the following error message:-

- troubleshooting error: "Error 5 getting session names" then,
- Error 1722 getting session names

On the machine that you cannot message to:
Use regedit to navigate to: (this access destination hostname via Admin mode from source machine from registry console itself. this again requires admin privileges. Type regedit from cmd prompt. Then Click File >> Connect Network Registry

















error connecting network registry pop-up usually appears when the destination windows firewall is activated and blocks all incoming connections. try to figure out this by allowing icmp ports. also, make sure remote registry services are running on either hosts.

and then change the destination registry settings AllowRemoteRPC value data from 0 to 1 base hexadecimal

HKLM\SYSTEM\CurrentControlSet\Control\Terminal Server

Then change the following value:

Name : AllowRemoteRPC
Type : REG_DWORD
Value : 1

Excel Function: Rupees to Words

Excel Function to Convert Rupees in Figure to Rupees in Word

Following function convert ( Rupees in figure ) numeric value in a Microsoft Excel worksheet cell into its equivalent in (Rupees in Word ) English words.

e.g. =SpellNumber(2450) will display as Rupees Two Thousand Four Hundred Fifty Only

After copying following code, Enable macro and use above function.

How to create the sample function Called SpellNumber

Start Microsoft Excel.
Press ALT+F11 to start the Visual Basic Editor.
On the Insert menu, click Module.
Type the following code into the module sheet.


Function SpellNumber(amt As Variant) As Variant
Dim FIGURE As Variant
Dim LENFIG As Integer
Dim i As Integer
Dim WORDs(19) As String
Dim tens(9) As String
WORDs(1) = "One"
WORDs(2) = "Two"
WORDs(3) = "Three"
WORDs(4) = "Four"
WORDs(5) = "Five"
WORDs(6) = "Six"
WORDs(7) = "Seven"
WORDs(8) = "Eight"
WORDs(9) = "Nine"
WORDs(10) = "Ten"
WORDs(11) = "Eleven"
WORDs(12) = "Twelve"
WORDs(13) = "Thirteen"
WORDs(14) = "Fourteen"
WORDs(15) = "Fifteen"
WORDs(16) = "Sixteen"
WORDs(17) = "Seventeen"
WORDs(18) = "Eighteen"
WORDs(19) = "Nineteen"
tens(2) = "Twenty"
tens(3) = "Thirty"
tens(4) = "Fourty"
tens(5) = "Fifty"
tens(6) = "Sixty"
tens(7) = "Seventy"
tens(8) = "Eighty"
tens(9) = "Ninety"
FIGURE = amt
FIGURE = Format(FIGURE, "FIXED")
FIGLEN = Len(FIGURE)
If FIGLEN < 12 Then
FIGURE = Space(12 - FIGLEN) & FIGURE
End If
If Val(Left(FIGURE, 9)) > 1 Then
SpellNumber = "Rupees "
ElseIf Val(Left(FIGURE, 9)) = 1 Then
SpellNumber = "Rupee "
End If
For i = 1 To 3
If Val(Left(FIGURE, 2)) < 20 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 2)))
ElseIf Val(Left(FIGURE, 2)) > 19 Then
SpellNumber = SpellNumber & tens(Val(Left(FIGURE, 1)))
SpellNumber = SpellNumber & WORDs(Val(Right(Left(FIGURE, 2), 1)))
End If
If i = 1 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & " Crore "
ElseIf i = 2 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & " Lakh "
ElseIf i = 3 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & " Thousand "
End If
FIGURE = Mid(FIGURE, 3)
Next i
If Val(Left(FIGURE, 1)) > 0 Then
SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 1))) + " Hundred "
End If
FIGURE = Mid(FIGURE, 2)
If Val(Left(FIGURE, 2)) < 20 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 2)))
ElseIf Val(Left(FIGURE, 2)) > 19 Then
SpellNumber = SpellNumber & tens(Val(Left(FIGURE, 1)))
SpellNumber = SpellNumber & WORDs(Val(Right(Left(FIGURE, 2), 1)))
End If
FIGURE = Mid(FIGURE, 4)
If Val(FIGURE) > 0 Then
SpellNumber = SpellNumber & " Paise "
If Val(Left(FIGURE, 2)) < 20 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 2)))
ElseIf Val(Left(FIGURE, 2)) > 19 Then
SpellNumber = SpellNumber & tens(Val(Left(FIGURE, 1)))
SpellNumber = SpellNumber & WORDs(Val(Right(Left(FIGURE, 2), 1)))
End If
End If
FIGURE = amt
FIGURE = Format(FIGURE, "FIXED")
If Val(FIGURE) > 0 Then
SpellNumber = SpellNumber & " Only "
End If
End Function

Know your RDP Port Number via Registry

Look for registry settings for remote access on Windows 2012:

Computer\HKEY_Local_Machine\System\CurrentControlSet\Control\Terminal Server\WinStations\RDP-TCP\PortNumber

Tuesday, 14 March 2017

Get a List of all SIDs


via PowerShell command from AD get a list of all SID in a domain residing in a specific OU:
Get-ADUser -Filter * -SearchBase "ou=users,dc=domain,dc=com" | Select sAMAccountName, SID

on local machine logged in profile SIDs are listed
@HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\WindowsNT\CurrentVersion\ProfileList\

SID is listed here

Keep it Clean, else it is a Smart Home for Germs!


You Have 21,000 Germs Per Square Inch On Your handheld device, whether it be laptop, mobile or desktop! Can you believe this? Yes, it's a proven fact.

"A microbiologist at the University of Arizona counted bacteria on workplace surfaces for a study sponsored by The Clorox Co., makers of Clorox bleach. Office toilet seats had 49 germs per square inch, he found. But desktops had almost 21,000 germs per square inch. Desks, phones, computer keyboards and mice are key germ transfer points because people touch them so often..." ~ CNN.com

When it comes to day to day electronic gadgets, all we tend to think about is the stuff we see on the screen, keyboard and handheld mobile devices. Most of us tend to neglect the basic fact of keeping them clean.

Every computer, laptop (in fact all electronic gadgets) have vents that channel hot air out. These vents should always enable air to pass out. You should avoid any blockages. For example, if you are using the laptop on a desk and have blocked one of the air vents with a book or something else on the desk, it’s safe to assume the laptop will overheat, regardless of the design! Also, if there are vents under the laptop, you could try propping it over the desk by placing the laptop on a couple of books, taking care not to cover the vents.

It is common for dust and dirt to block air vents. In fact, computers fail and have intermediate problems due to excessive dust build up. Apart from air vents, laptops breathe through the keyboard. Therefore, ensure the keyboard is free of any dirt or grime.

 
 Bacteria Farm that live on smart phones

In a recent report, scientists have also found over 500 types of bacteria and nearly 30 types of fungi from 27 handsets. It was a study from UK that had suggested that mobile phones and computer keyboards are dirtier than toilet seats. Both devices carry the sweat and grime and provide a perfect breeding ground for microbes.

The University Of Surrey students made imprints of their mobile phones in a Petri dish which was allowed to grow for a few days.  Most of it was harmless, but they did find Staphyloccoccus aureus – which can cause everything from staph infections to food poisoning.

Messy keyboard when opened found food particles, kitten hairs and pet pheromones, and so on..

So, what can you do?
     
Avoid to have refreshment in front of a laptop especially keyboard (eating biscuits, shawarma, burger, and of course sneezing in front of laptop screen)

Keep clean to stay healthy:

No matter how tempting it is, swabbing with damp cloth will do to an extent, however washing with water is always a bad idea!!

First of all, you’ll want to turn off your computer and unplug your keyboard.
Turn your keyboard over and try to shake out any loose particles. This part can be pretty gross, especially if you tend to eat at your desk.
It is suggested to get a can of compressed air and spray it over the keys to remove any extra debris that may be lying in between the cracks. Compressed air is available at any supermarket or computer store.
Take a slightly damp cloth and run it over the keys to remove any fingerprints and any other dirt that might be settling in on your keys.

For laptops, use dusting brush and just run it over the keyboard to make sure all remaining particles of dust, dirt, food, etc. are removed. Take a slightly damp cloth and run it over the screen to remove any fingerprints.

 In a "nutshell", you can easily disinfect and sterilize the surface by dampening the corner of the soft cleaning lint-free cloth with a bit of water and an antibacterial cleaner designed for cleaning surfaces or sanitizing spray made for disinfecting electronics and gently wipe off the back of the smart phone and the buttons. That should take care of some of the nasty critters. Avoid using paper towel or tissue paper to clean as that can leave scratches on the screen just because they are made of wood pulp.


Thursday, 9 March 2017

Experiencing difficulty in adding profile photo of employees

Basically, In active Directory we can use images up to 96×96 pixels in resolution. But in exchange 2013 you can use high resolution photo for the users which will be stored in user mailbox. This will allow you to upload photos up to 648x648 pixels.
If you dont have Photoshop or alternate software to edit pictures, don't worry this can be done online as well via http://resizeimage.net/


Requirements:
Photo should be in format *.jpg.
Photo should be in square shape. simply, Hight=Width.

Setting User Photos:
Two ways:

Users can upload their own photos through OWA >> Click on Display name (up right) >> Change Photo
Administrator can import photots in Exchange by using command below:
Single line command:

Set-UserPhoto “a.hany” -PictureData ([System.IO.File]::ReadAllBytes(“C:\UsersPhotos\a.hany96x96.jpg”)) –Confirm:$False

You may also set photo or remove profile photo by the following methods:

Set-UserPhoto -Identity "Andrew Hany" -PictureData ([System.IO.File]::ReadAllBytes("C:\Photo\Photo_Outlook\a.hany_96x96.jpg"))

This example uploads and saves a photo to Andrew Hany's user account using a single command.

Set-UserPhoto -Identity "Andrew Hany" -PictureData ([System.IO.File]::ReadAllBytes("C:\Photo\Photo_Outlook\a.hany_96x96.jpg")) -Preview; 

Set-UserPhoto "Andrew Hany" -Save

This example shows how to use two commands to upload and save a preview photo to Andrew Hany's user account. The first command uploads a preview photo to Andrew Hany's user account, and the second command saves the uploaded photo as the preview photo.

Set-UserPhoto -Identity "Andrew Hany" -Cancel

This example deletes the preview photo that was uploaded in the previous example.

Reviewing User Photos:

access the following URL to check

https://mail.contoso.com/ews/Exchange.asmx/s/GetUserPhoto?email=a.hany@contoso.com&size=HR648x648

Note: You need to change highlighted parts according to your environment.