Morning all, would be excellent if someone can advise on the following.
Need to find the best way of doing the following, not sure which route is the best.
Need to create a way of displaying what Active Directory groups are required to do certain things. Probably easier if I explain with an example.
Engineer is given 'Level 1' as there AD group level as standard. This contains 'Group 1', 'Group 2' etc... They need to logon to server 'Server 1' which requires 'Group 10', which is not a member of 'Level 1'. They wish to select (from a drop down box) a server and be told what 'group' they need to add to enable them to complete one of the actions (each server has 4 actions, which each have a different group). Additionally they need to see what groups are a member of a Level by looking up that level, and also what they get with there 'level'.
Hope that makes sense.
I was thinking a DB with tables for 'Levels', 'Groups' and 'Servers' and then have the results returned via queries onto forms. Not sure if this is the best way as I have not dabbled in this sort of stuff for years! Or would an HTA be better for this.
In the future it maybe a requirement to have the contents updated from a CSV file, so if Level 1 gets new groups, the import of the file will update this.
Just wanting to get the simple functionality sorted first though. Only constraint really is that it must run on Office 2003 (not 2007 or 2010).
Any advice would be much appreciated.
Need to find the best way of doing the following, not sure which route is the best.
Need to create a way of displaying what Active Directory groups are required to do certain things. Probably easier if I explain with an example.
Engineer is given 'Level 1' as there AD group level as standard. This contains 'Group 1', 'Group 2' etc... They need to logon to server 'Server 1' which requires 'Group 10', which is not a member of 'Level 1'. They wish to select (from a drop down box) a server and be told what 'group' they need to add to enable them to complete one of the actions (each server has 4 actions, which each have a different group). Additionally they need to see what groups are a member of a Level by looking up that level, and also what they get with there 'level'.
Hope that makes sense.
I was thinking a DB with tables for 'Levels', 'Groups' and 'Servers' and then have the results returned via queries onto forms. Not sure if this is the best way as I have not dabbled in this sort of stuff for years! Or would an HTA be better for this.
In the future it maybe a requirement to have the contents updated from a CSV file, so if Level 1 gets new groups, the import of the file will update this.
Just wanting to get the simple functionality sorted first though. Only constraint really is that it must run on Office 2003 (not 2007 or 2010).
Any advice would be much appreciated.