Category Archives: Active Directory

calculate lastlogon date with CSVDE


=IF(C2>0,C2/(8.64*10^11) – 109205,””) Explanation: C2 is the cell that contains the Timestamp. The If() statement hides the value if the user has not logged in. (8.64*10^11) is the number of nanoseconds in a day divided by 100. 109205 is the …

Read more »

Enabling Active Directory Recycle Bin

MS WIndows 2008R2 logo

Vereiste is 2008 R2 domain en forest level, dit is reeds het geval bij AP. Functie activeren middels PowerShell run as admin op SP001: Enable-ADOptionalFeature –Identity ‘CN=Recycle Bin Feature,CN=Optional Features,CN=Directory Service,CN=Windows NT,CN=Services,CN=Configuration, DC=ap,DC=global’ –Scope ForestOrConfigurationSet –Target ‘’ Overzicht naar voren …

Read more »