Spreadsheets
The following IT administration spreadsheets can be downloaded from Sysgrids;
Spreadsheet |
Description |
Links |
AD_Explorer |
Read lists of objects in OU's |
|
AD_GroupMemberQuery |
Lists LDAP group membership from multiple groups |
|
AD_MultiValuedQuery |
Read multivalue LDAP attribute properties from a list of objects |
|
AD_Query |
Read LDAP attribute properties from a list of objects |
|
AD_GroupMember_Update |
Modify LDAP group membership in multiple groups |
|
AD_MoveObject |
Move or rename lists of objects within the AD |
|
AD_MultiValued_Update |
Modify multivalue LDAP attribute properties in a list of objects |
|
AD_Object_Update |
Modify LDAP attribute properties in a list of objects |
|
CS_Explorer |
Read lists of objects of a server users and groups |
|
CS_GroupQuery |
Lists group membership from multiple groups |
|
CS_Pingchecker |
Pings a list of hosts and tables the reply |
|
CS_WMIQuery |
Uses WMI to query multiple server settings |
|
CS_DetailedWMIPingchecker |
Uses WMI to Ping a list of hosts and tables the reply (Full ping statistics) |
|
CS_GroupUpdate |
Modify group membership in multiple groups |
|
CS_PingAdvanced |
Pings a list of hosts and tables the reply (Enhanced features) |
User Guide | Download |
CS_QueryUpdate |
updates lists of objects of a server users and groups |
|
CS_WMIPingchecker |
Uses WMI to Ping a list of hosts and tables the reply |
|
Exchange_User |
Lists and updates an AD users mail enabled properties |
|
Exchange_WMIQuery |
Uses WMI to query multiple Excahnge server settings |
|
File_DomainDFS |
Lists AD domain DFS setup |
|
File_Explorer |
Reads lists of files and folders |
|
File_PropertiesShell |
Reads lists of files (shell) |
|
SQL Query |
Select query table or view on a SQL server |
|
SQL ServerInstances |
List SQL instances on a list of SQL servers |
|
SQL ServerProperty |
Lists SQL properties on a list of SQL servers |
No spreasheet on this site will directly alter computer settings or files
The first time a spreadsheet is launched it will write to the "HKCU\SOFTWARE\sysgrids\" area of the registry that the End User License Agreement (EULA) has been accepted. The spreadsheets contained on this site will make no other changes to any computers registry or files. The only exception to this is "CS_PingAdvanced" which needs to write temporary output to the Temp folder. Some spreadsheet are for the ammending of users and groups, these amendments are performed by the generation of powershell scripts that can be passed to administrators.
- Details
- Category: Uncategorised
- Published: 11 November 2013