Skip to main content
Tips & Tricks

Bulk User and Asset Options using a Spreadsheet of Items

  • September 7, 2022
  • 4 replies
  • 220 views
Bulk User and Asset Options using a Spreadsheet of Items
Deborah Prosser
Forum|alt.badge.img+16

We all know that you can use filters to create a specific view of users and assets then use bulk actions to quickly complete different tasks. However, what if you needed to complete these action items for a specific set of users or assets from a spreadsheet? Well, good news. This is simple with Incident IQ!

 

Let’s say you have a spreadsheet of users. You can simply copy and paste your list of users into Incident IQ and bulk add a new permission policy, change a location, or set a new role for users. The same concept applies for assets. For example, you can copy and paste your list of assets into Incident IQ and bulk change the locations.

 

The following steps demonstrate pulling a report within Users Explorer. 

 

  1. In your Users Explorer, open your list of All Users

pq559txwRUG-_-SSu4Eg7x6BhBayKj-siyMg4IoDEH32utUn353a6I7cl3sP9V24n-SVv8zvGfcE0Ow8xgyMFbTV1xlgDdmxu3QVOOsyF945F4H6XTbepvHr2uCRbF9gb48RHb7Zg_j6JIrGSeDMxXkTOnzsQQ1MJxYc4Q4cSmtzKF1kXjtumi0YLQ

 

  1. Select Filter > User Filters > User

wGEiVGexZKkmNHBNZuK54tcEoMYHhXcv9RMktGnm40nvHAe9Tc76ESukUQikyWgfPfxzMgkPFaL3Y4kCanGX8U-q9NWgl0Nc-HUQ-IJiKlCvfjj6ZXDulssmeLXL4cNoedYJ2XzPG6reRz-a9XmuDW8GfU9wTq-QK6yncr1E_9YsYIfa37YeGH4eRQ

 

  1. Copy the first & last names (as shown in iiQ) or emails from your list of users on your spreadsheet and paste them in the search bar within the filter window in Incident IQ. Once you paste your items, you will start to see the items being pulled and added under Selected Users. Select Save Selection.

LrSJWU17rH0uCQ4ax6Z-_1dRuaCtG0t0nZteVLryFyMJ0wrI2MHqSlLb2Mwm0yaeQdgtrTzAJp30SRYNCD99pGJzogE8s-aqQ5jgIG2LYOV_sULhBUeK407rF8CRsBCzaw3DZIJF1bYcL7ARpg9tqpOUuRj9qM6bKAI63oChB3xZ_NneR4funST8WQ

 

  1. You will now see a view of your selected users from your spreadsheet. At this point, you can apply your bulk actions. 

OvuUMKruwUFMaZD_EWuHEz2KtFvQDSBmQ7Rua2zGNKo6TYl1TIIh_tVH6GsqznMxeXhmyE5-D91XJu0-rvtlgkiWGrScL3sOQUGzCYoHzc63IceRLPMIWy4vPqbMVoUY8TieMvws4_zMlUws6SFGh6jMIUoYDS8mSH_mvlD1RnuX1i2eKGwleAbBOQ


 

There are many instances where we need to make updates, changes, etc. to a set of items from various spreadsheets. This feature is another way Incident IQ increases your efficiency and workflows!

 

How do you see this feature helping your workflow?

4 replies

Forum|alt.badge.img

We are limited to searching on 100 assets at a time? That makes tedious work when you are working on a list of thousands of devices


Kathryn Carter
Forum|alt.badge.img+18
  • Community Manager
  • 11066 replies
  • September 13, 2024

@DNikles 805e57 lebanonsd Once you are in a view or on asset explorer, you can select all assets: 

I hope this helps 😄


Forum|alt.badge.img

Yes, but to filter down to the assets I want in the view I have to import them by pasting in 100 at a time from a spreadsheet


Kathryn Carter
Forum|alt.badge.img+18
  • Community Manager
  • 11066 replies
  • September 13, 2024

@DNikles 805e57 lebanonsd  Here is an idea to increase that number: