Change associated account access for multiple users simultaneously

4 posts in this topic

Hi there,

Is there a way to change access/notification settings for multiple associated accounts at once (like a bulk select)?  I know I can bulk select machines, but this is still done at an individual account level.

When we have multiple users (set up for auditing purposes), whenever we add a new system we have to go through each account and grant them access to it.

Thanks again guys for all your work!

Share this post

Link to post
Share on other sites

Hi Michael,

Unfortunately no, this is not possible at the moment. We're considering on adding a setting on an account association to allow you to specify the access level and notifications access by default for newly added systems.


Share this post

Link to post
Share on other sites

I threw together a Powershell script that queries and modifies the SQL database to do this. I'm pretty sure it could be done completely as a SQL query, but my SQL ability is pretty limited.


$sqlserver = 'localhost'
$database = 'pcmonitor'

$computeridentifiers = @(Invoke-Sqlcmd -ServerInstance $sqlserver -Database $database -Query "SELECT [identifier] FROM [pcmonitor].[dbo].[Computers] WHERE [accountId] =1 AND [active] =1;") | select-object -expand identifier
$useridentifiers = @(Invoke-Sqlcmd -ServerInstance $sqlserver -Database $database -Query "SELECT [id] FROM [pcmonitor].[dbo].[Accounts] WHERE [id] != 1 AND [active] =1;") | select-object -expand id

foreach ($useridentifier in $useridentifiers) {
    foreach ($computeridentifier in $computeridentifiers) {
        Invoke-Sqlcmd -ServerInstance $sqlserver -Database $database -Query "IF NOT EXISTS (SELECT * FROM [pcmonitor].[dbo].[AssociatedAccounts] WHERE associatedAccountId = '$useridentifier' AND computerIdentifier like '$computeridentifier') INSERT INTO [pcmonitor].[dbo].[AssociatedAccounts] (primaryAccountId,computerIdentifier,associatedAccountId,readOnly,sendNotifications,version,active) VALUES (1,'$computeridentifier','$useridentifier',0,1,1,1)"


Share this post

Link to post
Share on other sites

Thanks for your contribution. I'd like to add that if you're changing the associated accounts directly in the database you also need to reload the accounts you've touched or to recycle the IIS application pool.


Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By PaulB
      Hi All,
      New to the software and love its ease of use. I am looking for an update from the roadmap on when the custom reporting may be available?
      Things like asset reporting on all PCs with x of software (Eg. office 2010) or License numbers of x software.Have a microsoft audit for example and need to gather all the FPP license numbers!
      All the information you appear to have already from the summary and detail asset reports its just the selection of those items into one report.
      or if any one knows a script that performs that task? 
    • By DBoivin
      For Oracle database monitoring the following items would ideally need to be monitored;  The tablespace sizes and projected growth, datafile size, oracle processes and their associated memory and cpu usage as well.  Even better would be SQL and PL/SQL monitoring tools which dynamically pull up problem SQL or PL/SQL as well.
      Thank you ! 
    • By Hanfelt
      Here is a pdf for setting up your synology nas with pulseway.
    • By Jason
      How do you restrict viewing of other client/customer data by end users when attempting to use "Security Roles" to allow them access to things such as the hardware assets and knowledge base views?
      We want to allow a client to view their hardware inventory (which we manage) from the portal, but they currently would be able to see data related to our other customers as well.