Differences

This shows you the differences between two versions of the page.

--- vendors:microsoft:ad:csvde [2018/05/17 19:56] – ↷ Page moved from code:java:vendors:microsoft:ad:csvde to vendors:microsoft:ad:csvde gerardorourke
+++ vendors:microsoft:ad:csvde [2024/08/23 12:07] (current) – gerardorourke
@@ Line 3: / Line 3: @@
 ==== Retrieving Base DN / LDAP Syntax for a domain account using Domain Name====
-Example Return all users who have a name Gerry
+Example Return all users who have a name starts with "Gerry"
 <code>
 dsquery user -name Gerry*
 </code>
-Example Return all users who have a login name is cuicldap
+Example Return computer with computer name of "MYCOMUNTERNAME"
+<code>
+dsquery computer -name MYCOMPUTERNAME
+</code>
+Example Return the users who have a login name is cuicldap
 <code>
 dsquery user -samid cuicldap
+</code>
+Example dsquery command to return all attributes for a specific user
+<code>
+dsquery * "CN=admin,CN=Users,DC=lab2,DC=purplepi,DC=ie" -attr *
+</code>
+Return specific attributes for a LDAP search
+<code>
+C:\Users\admin>dsquery * "CN=Albert Einstein,CN=Users,DC=lab2,DC=purplepi,DC=ie" -attr mail objectGUID
+  mail                       objectGUID
+  [email protected]    {38AB190B-814C-45C7-8A24-4808B3D88A6D}
+</code>
+Example Response:
+<code>
+objectClass: top
+objectClass: person
+objectClass: organizationalPerson
+objectClass: user
+cn: admin
+distinguishedName: CN=admin,CN=Users,DC=lab2,DC=purplepi,DC=ie
+instanceType: 4
+whenCreated: 04/18/2017 21:58:19
+whenChanged: 01/06/2020 15:47:48
+uSNCreated: 8198
+memberOf: CN=Cisco_ICM_Setup,OU=Cisco_ICM,DC=lab2,DC=purplepi,DC=ie
+memberOf: CN=Cisco_ICM_Config,OU=Cisco_ICM,DC=lab2,DC=purplepi,DC=ie
+memberOf: CN=Domain Admins,CN=Users,DC=lab2,DC=purplepi,DC=ie
+memberOf: CN=Users,CN=Builtin,DC=lab2,DC=purplepi,DC=ie
+memberOf: CN=Administrators,CN=Builtin,DC=lab2,DC=purplepi,DC=ie
+uSNChanged: 1151098
+name: admin
+objectGUID: {B18C5DA4-ABF2-492B-9A22-CC8985A91A33}
+userAccountControl: 66048
+badPwdCount: 0
+codePage: 1252
+countryCode: 1
+badPasswordTime: 132228658721839030
+lastLogoff: 0
+lastLogon: 132228924307313910
+logonHours: 0xff 0xff 0xff 0xff 0xff 0xff 0xff 0xff 0xff 0xff 0xff 0xff 0xff 0xff 0xff 0xff 0xff 0xff 0xff 0xff 0xff
+pwdLastSet: 131416540663230034
+primaryGroupID: 513
+objectSid: S-1-5-21-3443183386-3702885658-3434720438-1001
+adminCount: 1
+accountExpires: 0
+logonCount: 65535
+sAMAccountName: admin
+sAMAccountType: 805306368
+userPrincipalName: [email protected]
+lockoutTime: 0
+objectCategory: CN=Person,CN=Schema,CN=Configuration,DC=lab2,DC=purplepi,DC=ie
+dSCorePropagationData: 08/09/2019 14:15:51
+dSCorePropagationData: 04/19/2017 06:15:10
+dSCorePropagationData: 04/18/2017 21:59:14
+dSCorePropagationData: 01/01/1601 18:12:16
+lastLogonTimestamp: 132227992683243026
+msDS-SupportedEncryptionTypes: 0
+ADsPath: LDAP://LAB2-AD-01.lab2.purplepi.ie/CN=admin,CN=Users,DC=lab2,DC=purplepi,DC=ie
 </code>
 ==== CSVDE & LDIFDE ====