Archive for July, 2009

27
Jul
09

Filtering in FCC

Many of our customers spend a lot of time making up custom groups in their installation of FCC (or any other management application) but a fair number miss out on some quick methods to organize computers via some simple tricks within Core Console.

FCC allows users to create a series of automatic filters on user defined groups that can place workstations matching a specific criteria into the appropriate folder automatically. The way that this feature was implemented you can filter on any of the fields that are shown in the FCC console.

Windows 2003 Server-2009-07-17-09-26-32

As you can see there’s a number of them in there.

Most people catch on to the exact match options in the Filter portion of Core Console, but the third option in the list “matches regular expression”  is by far the most powerful as the end user can build their own query to match on any aspect of a given field.

For example if you wanted to filter for any computer starting with the word “Client” in the name you can use the filter below:

^Client*

The process for setting this up is shown below:

1. Right click on your user defined group and select Add/Edit Dynamic Filter.

 clip_image002

2. In the Dynamic Filter dialog box click on Add.

clip_image004

3. In the rule editor dialog give this rule a unique name and click Add to add a criteria to the filter.

 clip_image006

4. In the Clause Editor dialog select the Colum that you are going to sort on in the Column drop down box, and the option matches regular expression in the Comparison drop down box. Enter the filter that you want to use in the Value text entry field. In our case we want to capture any workstation who’s name starts with “client” so we enter “^client*” in the dialog. Click OK

clip_image008

5. If you want to add additional filters to this rule click on Add and add the appropriate filter as per step #4, if you are finished click on OK.

6. To apply this rule to the group ensure that it is checked, and click OK.

clip_image010

7. In this case you can see the two workstations, client1 and client2 both filtered into the user defined group automatically. The presence of the funnel beside the computers name shows that it has been added to the group based on a filter as opposed to being manually added.

 clip_image012

If you are not familiar with regular expressions and how they are constructed there are lots of resources out there on the web that can give you a heads up on how they are constructed.

16
Jul
09

FCC Tips and Tricks (Adventures in the database)

Heads up: this tip details some messing around in the back end of our database, if you don’t know what you are doing, or even if you do please give us a quick shout before making changes to the data within. There are things that you can do back there that will be very difficult to recover from. As always, make a backup before messing around!

I’ve gotten some emails lately from people looking to do things with PS and the FCC that are not something that we traditionally support, that being said there have been a couple of items that people might find of interest that we can do in the back end.

We would like to have a way to preserve replaced computers statistics. We get new computers in the middle of the year when the lease expired to replace existing ones using the same computer name so we have to delete the computer from the database and add the new one with different MAC address. By having the old computer deleted we no longer have the statistics of power savings for that computer to be added to the report.

Because we are using a SQL back end we can actually do this by manually manipulating the names of the computers that are being decommissioned so that they appear as a different workstation than the one that replaced it. We can get away with this as we don’t use the computers name as a unique identifier in our database back end. The SQL query below will go through the FCC database and mark all the managed workstations in the database with an identifier of your choosing.

To change the marker we are using you just have to change the text between the single quotes in the SQL statement below, I’m using DECOMISSIONED right now, but you can use any valid text string.

USE FaronicsEnterpriseDatabase
UPDATE FaronicsEnterpriseDatabase.dbo.tblB6267655_C0DE_4057_B801_F9FF8612A9C9_Status
SET tblB6267655_C0DE_4057_B801_F9FF8612A9C9_Status_MachineName=(‘DECOMISSIONED ‘+tblB6267655_C0DE_4057_B801_F9FF8612A9C9_Status_MachineName)
WHERE tblB6267655_C0DE_4057_B801_F9FF8612A9C9_Status_IsDiscovered is Null

You can see the results before:

Windows 2003 Server-2009-07-16-14-26-44

and after:

Windows 2003 Server-2009-07-16-14-26-57

running this query on my test systems here.

Now you are probably asking why we would mark all the workstations when we may only be decommissioning a few of them. Well due to the way that our Core Agent communicates we can mark all the workstations because the computers name resets each time that the agent service is restarted (the computer is rebooted) as shown below.

Windows 2003 Server-2009-07-16-14-30-13

Therefore the next time that a given workstation reboots it will automatically clear this flag and again display it’s proper name. The only issue with this is that you won’t be able to control the workstations that have been marked until they have rebooted as you have effectively changed the DNS name that FCC knows about and we won’t be able to connect to the workstation. You can change the method that Core Console uses to connect to rely on the IP address as opposed to the DNS name if you didn’t want to wait for the workstations to reboot (or wanted to trigger the reboot from the Core).

Next post I’ll touch on how to do filtering by the computer name using regular expressions, as it’s another trick that people have been interested in but that we admittedly don’t document all that well.