Examples - UMRA tables - Showing the content of a variable in a form
table
Creating a variable with table data and showing the content in a form
table
In this excercise, the project Collect Services is created which
collects the services information of a specific computer. These data can
subsequently be shown in another project defining how to manage these
services. Assigning script actions to the table data in the second project
falls outside the scope of this exercise, but is described in detail in
the document UMRA
Example projects: Service Management on our website.
The project created in this example can also be found in the directory
\Tools4ever\User Management Resource
Administrator\Example Projects\Generic\Tables\ManageServices\CollectServices.ufp
and ShowServices.ufp.
Creating project A - Collecting services
Start the UMRA
Console application and connect to the UMRA
Service: Select UMRA Service,Connect&ldots;
and connect to the computer on which the UMRA
Service is installed.
Choose File-->New. Select the option Form
project and click OK. Enter
the name of the project, Collect Services,
and click OK.
First we will set up the action that creates
and initializes the variable holding the name of the computer of which
we want to manage the services.
Drag the Set
variable script action into the script action window and configure
this script action as shown in the figure below. In this example, the
name of the computer is "COUNT".
Next, we need to collect the service status
information for the computer "COUNT".
In the Actions
bar, drag the script action List services
status from the Services folder to the script section window. Specify
the properties for this script action as shown in the figure below.
The UMRA software will connect to the computer
specified by %ComputerName% and
collect the status of all services. The status information includes the
name of the service, the operational state of each service (running, stopped),
type of service (automatic, manual, disabled) and so on. This information
is stored as a table in the variable %ServicesTable%.
In other words, this single variable will hold a table with multiple rows
and columns. The content of this variable can be displayed as a form table
in another project for managing the collected services.
Finally, the security settings for the project
Collect Services must be specified.
Choose the Form
properties command from the Actions
menu and click the Security tab.
For this exercise, you can set the group to "Everyone".
Save the project and close the project window
In the second project, a form table will be set up to display the content
of the variable %ServicesTable%.
Project B - Inserting a form table
to display table content in a variable
Choose File-->New. Select the option Form
project and click OK. Enter
the project name, Show Services,
and click OK.
Next, the project Collect
Services must be specified as an initial project to ensure that
the variable %ServicesTable% is
properly passed to the Show Services
project.
Right-click the Form window and select
Form properties&ldots;. Select the Initial
project tab and select Collect
Services as the initial project. Click OK.
Insert a table object in the Forms window. Select
the Generic table option and click
the Configure button.
The table data we wish to use are contained in
the variable %ServicesTable%,
so we need to select the generic table type Variable
as shown in the figure below.
For this table type, the name of the variable
and the columns contained in this variable need to be specified in the
Variable generic table tab.
Enter %ServicesTable%
in the Variable name list.
Specifying the column names is necessary
because a table variable only holds the data of the table, not the column
names. Built-in column templates are available for this purpose.
Select the column template
Services status (with config info) in the Columns
section and click the Set columns button.
This will include the column names "Computer", "Internal
name", "Name", "Service", "Status (text)",
"Status (code)", "Process ID", "Svc type (text)",
"Svc type (code)", "Interactive", "Startup-type
(text)", "Startup-type (code)", "Binary file"
and "Logon as"|. See the Help for more detailed information
regarding these status fields. Finally, click OK.
If you wish to make changes to the displayed
columns, you can do so in the Columns
tab.
Click the Columns
tab.
This window is used to configure which columns
must be shown in the form. Here you also specify the variables that are
passed to the UMRA Service when the end-user selects a service and presses
a submit button. On the left hand side, the available columns are shown.
These columns correspond with the columns configured in the previous step.
By using the add (->) and remove (<-)
buttons you can set up and modify a column configuration. In the example
shown, the form will have a table with 3 columns. The third column (Internal
name) will not be visible since it has a width of 0%. This column is included
since it uniquely specifies the name of the service, but there is no need
to display it for the end user. When the user selects a service and presses
a button, the value of this column is stored in variable %ServiceName%.
This variable is passed to the UMRA Service
and used for further processing.
Click OK.
When you run the preview, the resulting table as shown in the figure below.
You have now successfully configured a form
table holding content from a variable.
