bsharath
asked on
Reports in many combinations...
Hi,
I want a script with which i can take reports in many combinations/To check /To see the blanks etc...
I want a script that can get these details from the ADS users and computers properties.
Each differerent script
Office
Extension
Mobile
Title
Designation
Company
Each with the name if blank then leave the blank.From a particular OU.
For the Computer the description and Location.
Regards
Sharath
I want a script with which i can take reports in many combinations/To check /To see the blanks etc...
I want a script that can get these details from the ADS users and computers properties.
Each differerent script
Office
Extension
Mobile
Title
Designation
Company
Each with the name if blank then leave the blank.From a particular OU.
For the Computer the description and Location.
Regards
Sharath
I don't see any 'Extension' or 'Designation' fields in user properties!!
ASKER
Extension is the General Tab > Telephone Number and Designation is the Title box in Organisation tab
Click Start -> Run -> Cmd.exe -> OK
For users:
DSQuery * -Filter "(&(sAMAccountType=8053063 68)(|(!phy sicalDeliv eryOfficeN ame=*)(!te lephoneNum ber=*)(!mo bile=*)(!t itle=*)(!C ompany=*)) )" >Users.txt
For Computers:
DSQuery * -Filter "(&(objectClass=computer)( |(!locatio n=*)(!desc ription=*) ))" >Computers.txt
For users:
DSQuery * -Filter "(&(sAMAccountType=8053063
For Computers:
DSQuery * -Filter "(&(objectClass=computer)(
ASKER
Farhan i get this...
C:\>DSQuery * -Filter "(&(sAMAccountType=8053063 68)(|(!phy sicalDeliv eryOfficeN am
e=*)(!telephoneNumber=*)(! mobile=*)( !title=*)( !Company=* )))" >Users.txt
Dsquery has reached the default limit of 100 results to display; use the -limit
option to display more results.
Any help the other Q's....
C:\>DSQuery * -Filter "(&(sAMAccountType=8053063
e=*)(!telephoneNumber=*)(!
Dsquery has reached the default limit of 100 results to display; use the -limit
option to display more results.
Any help the other Q's....
ASKER
I get this...
C:\>DSQuery * -Filter "(&(objectClass=computer)( |(!locatio n=*)(!desc ription=*) ))
" >Computers.txt
Dsquery has reached the default limit of 100 results to display; use the -limit
option to display more results.
C:\>DSQuery * -Filter "(&(objectClass=computer)(
" >Computers.txt
Dsquery has reached the default limit of 100 results to display; use the -limit
option to display more results.
For users:
DSQuery * -Filter "(&(sAMAccountType=8053063 68)(|(!phy sicalDeliv eryOfficeN ame=*)(!te lephoneNum ber=*)(!mo bile=*)(!t itle=*)(!C ompany=*)) )" -Limit 0 >Users.txt
For Computers:
DSQuery * -Filter "(&(objectClass=computer)( |(!locatio n=*)(!desc ription=*) ))" -Limit 0 >Computers.txt
DSQuery * -Filter "(&(sAMAccountType=8053063
For Computers:
DSQuery * -Filter "(&(objectClass=computer)(
ASKER
For the computers Dsquery i just get this,
"CN=DEV-CHEN-PC632,CN=Comp uters,DC=D evelopment ,DC=Group, DC=co"
For users i just get this...
"CN=Gino Salvato,OU=Named Accounts,OU=User Accounts,OU=Countries,DC=D evelopment ,DC=Group, DC=co"
"CN=DEV-CHEN-PC632,CN=Comp
For users i just get this...
"CN=Gino Salvato,OU=Named Accounts,OU=User Accounts,OU=Countries,DC=D
You mean without Limit 0 it is showing so many records? and with Limit parameter it is showing only one record?
ASKER
With and without "-limit 0"
I just get the object full path as mentioned below...
Only where the user or computer is in which OU...
I just get the object full path as mentioned below...
Only where the user or computer is in which OU...
Above query will just show User or Computer CN if it has any field blank.
ASKER
Ok got confused sorry. Can you remove the OU path in both...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Farhan.
Any help with the other Q...'s
Any help with the other Q...'s
Thanks Sharath, Im looking on your other posts.