0 votes

Morning team,

I have two questions about reports

  1. I created a container for our helpdesk and adding reports there. Each time a new report was added, I need to manually select either the report or the whole cointainer again, so it is visible for the team. Any way to auto enable reports under a certain container?

Before image.png

After image.png

  1. I have this "dynamic" report with parameters image.png

And this is the search option image.png

Now I want to achieve the following

  • Adding own pre defiend values like "AT", "DE", "PL"
  • Based on selection, the company and country name should be set
  • For example, I select "DE", then country name should be Germany and company name should be MyCompany

Is that possible?

Thanks!

by (1.5k points)

1 Answer

0 votes
by (284k points)
selected by
Best answer

Hello,

Any way to auto enable reports under a certain container?

Unfortunately, there is no such possibility. However, thank you for the suggestion. We forwarded it to the corresponding department for consideration.

I have this "dynamic" report with parameters

Unfortunately, there is no such possibility. However, we have the feature in our plans for future releases. As a solution, you can use a script to generate the report and have just a single drop-down list parameter. All the dependencies will be specified in the script. Unfortunately, we do not have anything like that in our repository, but the following article should be helpful: https://adaxes.com/sdk/GeneratingReports.

0

Hi

Unfortunately, there is no such possibility. However, thank you for the suggestion. We forwarded it to the corresponding department for consideration.

That would be great, thanks!

Unfortunately, there is no such possibility. However, we have the feature in our plans for future releases. As a solution, you can use a script to generate the report and have just a sing drop-down list parameter. All the dependencies will be specified in the script. Unfortunately, we do not have anything like that in our repository, but the following article should be helpful: https://adaxes.com/sdk/GeneratingReports.

I will have a look and try - would you be able to support me, if I encounter any issues or blockers?

+1

Hello,

We will do our best to help you with the script in case you encounter issues.

0

Hi,

I am currently trying to create this report:

  • Enter a startDate
  • Enter a endDate
  • Select value (A, B, Both)

No I need to find all users

  • if A is selcted
    • all Users where A is within range of startDate and endDate
  • if B is selcted
    • all Users where B is within range of startDate and endDate
  • if Both is selcted
    • all Users where A OR B is within range of startDate and endDate

A and B has a format like this in AD string_with_info_YYYY-MM-DD

This is my current approach

# Retrieve the type of search (A, B, or Both)
$searchType = $Context.GetParameterValue("param-searchType")

# Retrieve the start and end date
$startDate = $Context.GetParameterValue("param-startDate")
$endDate = $Context.GetParameterValue("param-endDate")

# Convert start and end dates to YYYY-MM-DD format for comparison
$startDateFormatted = [DateTime]::Parse($startDate).ToString("yyyy-MM-dd")
$endDateFormatted = [DateTime]::Parse($endDate).ToString("yyyy-MM-dd")

# Validate that the dates are in the correct format
if (-not $startDate -or -not $endDate) {
    throw "Both start and end dates must be specified."
}

# Initialize an LDAP filter to retrieve all users with either A or B attribute set
$ldapFilter = "(&(objectClass=user)(|(A=*)(B=*)))"

# Apply the filter to the directory searcher
$Context.DirectorySearcher.AppendFilter($ldapFilter)

# Load the required properties during the search 
$Context.DirectorySearcher.SearchParameters.PropertiesToLoad.AddRange(@("A", "B"))

# Execute the search and filter users by date in PowerShell after retrieving the results
try {
    $searchIterator = $Context.DirectorySearcher.ExecuteSearch()

    while ($Context.MoveNext($searchIterator)) {
        $searchResult = $searchIterator.Current

        # Retrieve the value from the search result properties
        $A = if ($searchResult.Properties.Contains("A")) { [string]$searchResult.Properties["A"][0] } else { $null }
        $B = if ($searchResult.Properties.Contains("B")) { [string]$searchResult.Properties["B"][0] } else { $null }

        # Extract the date part from A and B strings
        if ($A) {
            $ADate = $A.Substring($A.Length - 10)  # Extract the last 10 characters (YYYY-MM-DD)
        }
        if ($B) {
            $BDate = $B.Substring($B.Length - 10)  # Extract the last 10 characters (YYYY-MM-DD)
        }

        # Perform the comparison based on the search type
        if ($searchType -eq "A" -and $ADate -ge $startDateFormatted -and $ADate -le $endDateFormatted) {
            $Context.Items.Add($searchResult)
        } elseif ($searchType -eq "B" -and $BDate -ge $startDateFormatted -and $BDate -le $endDateFormatted) {
            $Context.Items.Add($searchResult)
        } elseif ($searchType -eq "Both" -and (($ADate -ge $startDateFormatted -and $ADate -le $endDateFormatted) -or ($BDate -ge $startDateFormatted -and $BDate -le $endDateFormatted))) {
            $Context.Items.Add($searchResult)
        } 
    }
} finally {
    if ($searchIterator) { $searchIterator.Dispose() }
}

However, no result is shown.

I am not sure if I get the correct value of each found user for A and B to compare it

0

Hello,

What exactly do you mean by stringwithinfo_YYYY-MM-DD? Please, provide live examples.

Also, please, provide us with a screenshot of the Multi-server environment dialog. The dialog displays how many Adaxes services you have and what their versions are. For information on how to view it, see https://www.adaxes.com/help/MultiServerEnvironment. You can post the screenshot here or send to us at support@adaxes.com.

Related questions

+1 vote
1 answer

When building a form, is there a way I can request the user to answer questions? I understand there is the adm-customattributes that aren't stored in AD, but I don' ... the reason why, rather than just seeing "What" change is being requested. Thank You!

asked Mar 1, 2023 by Edogstraus00 (490 points)
0 votes
1 answer

Is there anyway we can get an Adaxes administrator to be able to access the security the questions and answers from the “Password Self-Service Policies” portal for our users?

asked Feb 17, 2022 by JoeG (40 points)
0 votes
1 answer

We are trialing Adaxes and are wondering the following two things are possible. Is it's possible to have the order of Authentication methods adjusted ? Is it possible to import an ... 't look to exist, but would it be viable to add them as feature requests ?

asked Jul 6, 2020 by dgrandja (70 points)
0 votes
1 answer

I have a few questions on licensing. Which accounts are excluded from the license count? I understand you can exclude users, by OU possibly. I'm more interested ... . What happens during license validation? What happens if you go over license count?

asked Jul 2, 2020 by ComputerHabit (790 points)
0 votes
1 answer

is it possible to allow a user to enroll for both options, or even only one option out of the two available? I would like to give my users the choice to use either. Some users may not want an authenticator, but other's might do.

asked Nov 6, 2019 by mashworth (80 points)
3,499 questions
3,191 answers
8,141 comments
547,341 users