Spreadsheets

The following IT administration spreadsheets can be downloaded from Sysgrids;

 

Spreadsheet

Description

Links

AD_Explorer

Read lists of objects in OU's

User Guide   |   Download

AD_GroupMemberQuery

Lists LDAP group membership from multiple groups

User Guide   |   Download

AD_MultiValuedQuery

Read multivalue LDAP attribute properties from a list of objects

User Guide   |   Download

AD_Query

Read LDAP attribute properties from a list of objects

User Guide   |   Download

AD_GroupMember_Update

Modify LDAP group membership in multiple groups

User Guide   |   Download

AD_MoveObject

Move or rename lists of objects within the AD

User Guide   |   Download

AD_MultiValued_Update

Modify multivalue LDAP attribute properties in a list of objects

User Guide   |   Download

AD_Object_Update

Modify LDAP attribute properties in a list of objects

User Guide   |   Download

CS_Explorer

Read lists of objects of a server users and groups

User Guide   |   Download

CS_GroupQuery

Lists group membership from multiple groups

User Guide   |   Download

CS_Pingchecker

Pings a list of hosts and tables the reply

User Guide   |   Download

CS_WMIQuery

Uses WMI to query multiple server settings

User Guide   |   Download

CS_DetailedWMIPingchecker

Uses WMI to Ping a list of hosts and tables the reply (Full ping statistics)

User Guide   |   Download

CS_GroupUpdate

Modify group membership in multiple groups

User Guide   |   Download

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

User Guide   |   Download

CS_WMIPingchecker

Uses WMI to Ping a list of hosts and tables the reply

User Guide   |   Download

Exchange_User

Lists and updates an AD users mail enabled properties

User Guide   |   Download

Exchange_WMIQuery

Uses WMI to query multiple Excahnge server settings

User Guide   |   Download

File_DomainDFS

Lists AD domain DFS setup

User Guide   |   Download

File_Explorer

Reads lists of files and folders

User Guide   |   Download

File_PropertiesShell

Reads lists of files (shell)

User Guide   |   Download

SQL Query

Select query table or view on a SQL server

User Guide   |   Download

SQL ServerInstances

List SQL instances on a list of SQL servers

User Guide   |   Download

SQL ServerProperty

Lists SQL properties on a list of SQL servers

User Guide   |   Download

 

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.