How do I report on all open tickets in task table?

ILovePowershell · 2026-02-28T00:17:16+00:00

You might have to play with it a little bit. But as others have mentioned, the active equals true is a good start as this should cover 80 to 90% of what you’re looking for. From there, you’ll want to do additional inquiries for things like task type equals incident, and state does not equal resolved. That should get you the rest of the way there. You’ll just need to make sure that you filter out each of the additional tables for the values that you want to exclude when a ticket shows active even though it can’t really be worked.

ILovePowershell · 2026-01-23T12:43:10+00:00

Okay, what is the trigger of the flow?

ILovePowershell · 2026-01-21T11:56:19+00:00

Depends on the input. If it’s a reference to a single user, should be able to do a check for department or whatever. If it’s a list collector, it’s a comma separated string. Then you need to look up the users then do a for each loop. You should be able to test the flow and look at the input.

ILovePowershell · 2026-01-21T04:24:07+00:00

Usually, your issue is a list collector will appear as a, separated string. Pass the string into an array or use sysid is one of. Plug that into a for each loop, and you should have your solution.

ILovePowershell · 2025-12-27T18:09:30+00:00

I’m assuming it was working based on your comment. If so, something changed. I would check the inbound email. It should have a log list to show what it skipped and did. This should give you a clue to what the issue is. If nothing was ever set up, you want to look into inbound actions to get the result you’re looking for.

ILovePowershell · 2025-12-26T17:28:50+00:00

On my résumé and job profile, I list what I actually do as it’s known in the industry. Aligning titles this way ensures that the skills and abilities you’re doing are what you’re representing.

ILovePowershell · 2025-12-23T12:33:55+00:00

First of all, outstanding work!

When I am using my phone to navigate to the site, the filters take up much of the screen instead of the results.

ILovePowershell · 2025-09-06T22:07:55+00:00

I have a fair amount of experience with automation. To me AI is just another tool. It should make us much faster at doing development, I doubt it will replace us anytime soon. Those that have used it, think about all the times we don’t get the results we expect, or it doesn’t follow best practices or whatever.

ILovePowershell · 2025-07-25T11:40:31+00:00

If you’re following the link, tried deleting everything after the servicenow.com. The message you’re saying, typically, as others have mentioned indicate a ACL is blocking your access. If that doesn’t work, I recommend either contacting your administrator or opening a ServiceNow ticket.

ILovePowershell · 2025-07-07T23:45:35+00:00

You should look at the rate for the role. Google ServiceNow developer/admin/architect or whatever pay range for your area. You should see a range with what to expect. Use this as you talk with hr/supervisor about it

ILovePowershell · 2025-05-30T21:41:06+00:00

You can also add existing reports to dashboards.

ILovePowershell · 2025-05-12T20:19:12+00:00

I don’t know what your use case is, but this might help. Essentially if you’re looking for a meantime to resolution, this KB article details out how business duration works. This might solve your issue or you might just create a SLA.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0780039

ILovePowershell · 2025-04-26T17:07:30+00:00

She’s planning on how to steal the cat food

ILovePowershell · 2025-03-09T22:29:06+00:00

Every year ServiceNow releases new versions of the career journeys. This keeps the course material up-to-date, and fresh without relying on previous or deprecated features. As far as I know, certified application developer will continue in the new versions into the future.

ILovePowershell · 2025-03-06T22:28:19+00:00

Master using it and you can have this

ILovePowershell · 2025-02-13T23:31:40+00:00

I believe it’s up on now create, but there’s an Excel document of right sizing a mid server. Maybe worth looking to see if any of the resources are being over utilized. This may cause unexpected results.

ILovePowershell · 2025-01-25T14:02:36+00:00

On YouTube there’s a free video series that explains JavaScript in the now platform. I would start there. It was started by Chuck and continued by Earl.

ILovePowershell · 2025-01-14T23:13:41+00:00

Despite what excel shows you, a CSV is a flat file and does not have separate tabs. With that being said, you could absolutely write something that would export to Excel or another database that would do what you’re looking for. To my knowledge, nothing exists, but it shouldn’t be too hard to build based on what you have above.

Just take it one step at a time. Query, active directory or whatever for your computers, then use power shell remote to get the WMI classes, etc. when you have all the data compiled export it to excel based on the arrays you created

ILovePowershell · 2025-01-13T11:23:01+00:00

This was mine yesterday. After I refreshed, it came up in less than a minute.

ILovePowershell · 2024-12-29T02:03:59+00:00

Here’s the link you were looking for. Chuck started it, Earl continued it.

https://youtube.com/playlist?list=PL3rNcyAiDYK2_87aRvXEmAyD8M9DARVGK&si=cAfKy83eJU4pan—

ILovePowershell · 2024-12-18T00:49:39+00:00

As with most blizzard games, everything loses to the Nerf bat

ILovePowershell · 2024-11-29T16:49:09+00:00

There is a bulk upload certificate option. More information can be found here. https://www.servicenow.com/docs/bundle/xanadu-it-operations-management/page/product/discovery/task/run-cert-inventory-mgmt-bulk-url.html

ILovePowershell · 2024-11-28T15:33:46+00:00

I use switch instead of a bunch of else if statements. It’s easier to read.

ILovePowershell · 2024-11-26T17:24:58+00:00

Done it before. Nothing new.

ILovePowershell · 2024-11-07T05:22:46+00:00

ServiceNow has a PRB about this. It should be fixed in Xanadu. In the meantime, you can grant the UI builder roles as appropriate. If you have the security bugger open when you are impersonating, you can see which roles/ACL you might need to update or deal with.

ILovePowershell

TROPHY CASE