BES agent to BES DB first-time registration

(imported topic written by SystemAdmin)

Hello,

Does the BES server keep track of when an agent first registered itself to the data base? I’m trying to report on how many new agents were introduced to the console this week. There is nothing on the workstation that can be used to indicate a new workstation - and they get a standard image - so any timestamps of local files or registry entries could be misleading. If there is a field in the DB - how would one get the relevenace - since it is not something that you would query against the actual agent - unless the agent has that info stored locally as well.

If BES keeps track of the date when an agent first registered - that would be sweet!

Cheers,

Mike

(imported comment written by BenKus)

Hi Mike,

You can try one of these:

creation time of folder “__BESData” of parent folder of regapp “BESClient.exe”

or

subscribe time of current site

and see if t hey meet your needs…

Ben

(imported comment written by SystemAdmin)

Very cool! Thank you Ben. The “subscribed time” looks to be perfect. The “creation time of folder” looks to show when it was installed on the image - so that one is misleading. But the other looks like it will work. Thank you very much for that.

To verify the subscribe time is the first time it subscribes, correct? Will that ever change or get updated to a newer timestamp?

Thank you again.

Mike

(imported comment written by BenKus)

Hey Mike,

I think the subscribe time will get updated if the agent is reset… I am not sure if it will get reset for other reasons (like if you updated your BigFix license) and we would need to test that.

Ben

(imported comment written by SystemAdmin)

Thanks Ben, that is good to know. I’ll keep an eye on that. It appears that agent version updates do not effect the “subscribed time” - which is good. I have a lot of systems that go back to when Big Fix was first installed on them - and that is several license updates as well. If anything it is a lot closer to having a solid registration date - then not. This was a huge help. Thank you.

Cheers,

Mike

(imported comment written by jessewk)

also see: http://forum.bigfix.com/viewtopic.php?id=1868

(imported comment written by cstoneba)

“subscribe time of current site” works for me too, but now I would like to create a webreport that shows computers that have a (current date) - (subscribe time of current site) <24hours.

Then I will have that report scheduled to email out daily so I know new computers that are brought online. Ben, any help there? thanks

(imported comment written by BenKus)

Probably the easiest thing to do would be to make a new property with the relevance:

now - subscribe time of curernt site < 24*hour

And then have a scheduled report run once a day with the “True” values…

Alternately, you could write a custom report with the session relevance that looked something like this:

(name of computer of it, value of it) of results (bes property “Last Report time”, bes computers) whose (now - (value of it as time) < 24 * hour)

Ben

1 Like

(imported comment written by cstoneba)

thanks Ben. I think I am close. I created a new property called “First Check-in” and then created a scheduled alert with the following relevance:

(name of computer of it, value of it) of results (bes property “First Check-in”, bes computers) whose (now - (value of it as time) < 24 * hour)

When I click the Test button, I get the out put that I am looking for, but when I actually receive the email, it is blank.

(imported comment written by BenKus)

You need to put the relevance in a custom report and then schedule the report to run daily…

Ben

(imported comment written by cstoneba)

thanks. I hate to ask another question, but how would I add the value of the bes property of “Location By Subnet” of it, to this relevance?

(imported comment written by BenKus)

Try this:

(names of item 2 of it, values whose (now - (it as time) < 24 * hour) of results (item 0 of it, item 2 of it),values of results (item 1 of it, item 2 of it) ) of (bes property “First check-in”, bes property “Location by Subnet”, bes computers)

Ben

(imported comment written by cstoneba)

thanks ben.

(imported comment written by russwm91)

Hello,

I must be missing something I have tried every possible combo of subscribe time of current site in my relevance debugger and it always gives me an error. I’m using 7.5.22 latest and always get the same error "Error: Singular expression refers to nonexistent object. I tried assigning a site like subscribe time of current site “bessupport” and that fails too. I tried looking at the online inspector website that didn’t give me any idea on what I’m missing. I would really like to get this to work, so I can track what new devices are being installed in my network.

Thanks,

Russ

(imported comment written by cstoneba)

you first need to have a property called “First check-in”. This property displays the date/time of the first checkin time of the client. Additionally, you can’'t run the it in the relevance debugger for testing, it needs to be ran in either the presentation debugger, or what I did was create a new schedule in web report and click on the test button, then throw the code in there.

(imported comment written by russwm91)

Hello

I was able to get the BES properties to work in the console now I having issues with the below web reports.

Ok I noticed this is suppose to be in a custom web report or blank report. I attempted to do this but when I copy the relevancy statement in to the custom report and schedule it out to run it runs only with the results of the relevancy statement. I know that I’m missing a bunch of code for the HTML blank report and can’t just paste in a relevancy but does anyone have a basic template that I can use in a blank report then add in the session relevancy clause to make it work. I wish the alert schedule piece would work correctly when you give it relevancy to match and triggered but it doesn’t. I spend over an hour trying to get it to kick off and email but it never does.

Thanks,

Russ

(imported comment written by BenKus)

Hey Russ,

The basic idea for a custom report is:

Report Title

Other text, javascript, and other html…

<?Relevance insert session relevance here ?>

(imported comment written by CRLima)

Hi Mike, it’s easy. Creates a custom property with relevance code below for showing the create date of folder of the “BESClient.exe”. After, creating a web report to display results for custom property.

if (exists parent folder of regapp “BESClient.exe”) then (creation time of parent folder of regapp “BESClient.exe”) else (creation time of parent folder of regapp “BESClient.exe”)

In this case it works to me.

(imported comment written by AakashK)

Hi CRLime,

Can you please help me out for the relevance for non-windows as well as its coming undefined for non-windows systems.

Thanks,

AakashK

(imported comment written by jgstew)

This should be cross platform:
http://bigfix.me/relevance/details/2998859

creation time of parent folder of client