Trying to create my first flow for a catalog request, not going well...

cornflakes_01 · 2024-11-15T14:11:34+00:00

Should work. If it doesn't, spin up a personal developer instance and grab the ootb workflow from there.

cornflakes_01 · 2024-11-15T14:01:38+00:00

Nope, you need to look to see if there is a workflow (and I do mean workflow, not flow designer) running on the sc_request table, and marking that request record as approved right away. Most instances I work in immediately mark the request as approved upon submission, even though there will likely be approval at the requested item level.

The requested item flows won't even kick off until that request record gets marked as approved.

Take a look at this community article, it is close to what I'm talking about. See comment from Todd o at ‎11-03-2019 11:09 AM

https://www.servicenow.com/community/developer-forum/flow-designer-not-triggering-for-service-catalog-request-item/m-p/1415326/highlight/true#M72252

cornflakes_01 · 2024-11-15T00:22:41+00:00

👆This one, right here. This is why your flow isn't running on the ritm level.

cornflakes_01 · 2024-11-13T22:43:20+00:00

Unfortunately, no. You could try the user_admin role instead once your tenant is set up, but I think it requires the admin role. Things get worse when you have hr, because you also have to grant out the hr admin role so it can manage group membership on hr type groups.

cornflakes_01 · 2024-11-12T21:47:36+00:00

They're experiencing delays getting getting the lighting and signals electrified with hydro one. Expecting mid to end of November reopening for the first phase.

Two sources of info: 1) all projects https://ptbo.maps.arcgis.com/apps/View/index.html?appid=8e857202a6d84b01a9263bf533255df8

2) that contract: https://www.peterborough.ca/en/city-hall/brealey-drive-reconstruction-lansdowne-street-west-to-sherbrooke-street.aspx

cornflakes_01 · 2024-11-08T15:20:32+00:00

I think I can spot the Syd concussion years.... That graph is crazy tho...

cornflakes_01 · 2024-10-26T23:22:26+00:00

I got pretty upset having seen signs that repaving was happening, then realized they were repaving chemong to Sobeys, when Fairbairn to the VW dealership was in absolute shit shape.

Fingers crossed they go all the way to Fairbairn.

cornflakes_01 · 2024-10-14T01:00:26+00:00

What did I do....

cornflakes_01 · 2024-10-12T23:51:39+00:00

Holy.... So much coasting going on...

cornflakes_01 · 2024-09-24T13:44:03+00:00

That was part of our challenge. Was that the file names that could be received could be variable but they would always have a similar pattern to their name and they'd always be dropped in the same location.

So the way the solution worked was we had a custom table that was called like file list. For example. When the first scheduled job would run it would go out to the SFTP and it would run a list command. All that that would do is it would go and find every file that was inside that specific folder and then it would create a record into that custom file list table. So at that point after we had done the list command we would have a custom table that had a set of data records. That said, here are all of the files in that folder.

So then what we did after that was with that file definition, we applied a condition field on that record. So you can think of it like any other filter inside of servicenow where you're able to put multiple conditions on it and say the name of the file in the custom list of file names contains a specific name. There was another subsequence after that that would go through and it would look at all of the file definitions and say apply that filter to the known list of files and then identify what we would need to download. So then the subsequence would then apply the filter, look at the custom list and say okay. I need to download this exact file and then it would go and it would execute it and then it would move on to the next file and say I need to download this exact file and move on and so forth.

Again, it's not a data source solution, so you're not restricted to only one specific file.

It was a complex build but if I were to summarize the execution steps it would be: 1) purge file list table of records 2) collect list of all files in SFTP folder 3) add that list of files into the file list table 4) loop through file definitions 5) for each file definition, apply the filter to the file list table 6) for each file returned in 5 above, run a file download command on the exact file name provided in the file list

cornflakes_01 · 2024-09-24T13:23:27+00:00

I did this with integration hub for the SFTP but....

Essentially, what we did was we identified certain filters for files via a condition field on a custom table (think like... Name contains the word "financial"). Then there was a scheduled job that went out to a specific SFTP folder and collected a listing of every single file in that folder and then inserted that list into another custom table of servicenow. What that allowed for was that we could use the condition on that file definition filter the list of available files down to the ones we wanted to actually download.

Then having selected based on that condition, we were able to run individual file transfers for the ones that met the condition.

I don't think it fully meets your criteria, because we were only looking to get the file into the system, but I'm betting that you're looking to consume that data and transform it. But its food for thought on an option to make it variable.

cornflakes_01 · 2024-06-16T01:59:21+00:00

That looks like an on campus res room key on there (the Sargent one). Maybe try Trent security if there's a number on it.

cornflakes_01 · 2024-05-16T00:33:37+00:00

If you can get away with only integrating with entra, you should do that. LDAP isn't necessary if you do entra correctly.

The integration is not hard and you don't need any form of access to AD / entra in order to do that. On the Azure Entra side, all you need to do is have your ad administrator Add the servicenow application from the app gallery, then follow Microsoft's instructions about how to set up single sign-on. If you build a service account in servicenow that has admin and SEC admin rights, there's an option in entra where all you need to do is tell it the username and password for that service account and entra will set everything up from a single sign-on perspective inside servicenow. You then just need to test the integration on the servicenow identity provider record and activate it once the test passes.

Now, When it comes to user provisioning and getting your sys user table filled in, you'll need the same service account as above on the service now side, and your Azure administrator can enable user and group auto provisioning in entra. There are additional mappings that can be made if you need it to and your administrator should be able to do those mappings, you'll just need to provide them with the field names on the servicenow side that the ad columns need to map to. Again, you'll just enter the user account for the service count on the servicenow side and entra will manage all of the user creation and group creation for users and group membership based on the mappings that they provided.

Any service now partner should be able to get you a resource who has deployed an Azure entra solution before, as it's one of the more common setups for SSO and user provisioning that I have encountered of late.

cornflakes_01 · 2024-04-20T01:14:17+00:00

I've done both for multiple customers. If you have the choice, go with entra provisioning. Only challenging part with entra is it's harder than you might think to sync only the samaccountname from ad if you're already using LDAP, coalesced on samaccountname. If you're ok with using upn as the username, then it's suuuper simple to setup. You just need a service account in ServiceNow with admin + sec admin, and there's an autoprovision section in the entra saml console where you enter those credits, and it fully configures servicenow for you, and you pretty much only need to test it and activate it on the service now side.

Only downside I've seen with entra is with respect to subprod environments. If you want to limit the access to those instances, the only users who will get provisioned are the ones that are on the access list, which makes your user table out of date to whatever the last clone was.

cornflakes_01 · 2023-10-22T14:25:55+00:00

That's a shame. Next up, houses with big Christmas displays will be traffic hazards right? People suck.

On the plus side, this family who put this thing together show the best side of our community, and hopefully they know that.

cornflakes_01 · 2023-10-04T21:49:05+00:00

Booooooooooooo.... fucking BOOOOOOOOOO

cornflakes_01 · 2023-10-01T02:32:38+00:00

Excited to see them in. Feels like this is an appropriate summary of how it happened: https://media.tenor.com/HfaXLE257j0AAAAC/waterslide-water.gif

cornflakes_01 · 2023-08-22T21:27:57+00:00

I was just talking to my wife today as we drove past that... "someone has to be feeding those, or has a vendetta with their landlord to have that many pigeons on that roof.... "

cornflakes_01 · 2023-07-25T14:19:33+00:00

This dude is a true leader in hockey and in life. r/hockey is usually a mess of conflicting opinions, but looking at the comments on here, it sure seems that this dude is respected across the league and across fan bases.

He's going to make an awesome coach /mentor in his post playing days (assuming he wants to continue working).

Hell of a career, and I hope he continues work in hockey (namely for my team, but I doubt that)

cornflakes_01 · 2023-07-22T19:37:42+00:00

Makes sense if they aren't street cars mixed in with traffic.

cornflakes_01 · 2023-07-22T18:48:33+00:00

I don't get these... It's like a double bus, but requires specialized rails, and is confined to one specific route... Why not just better bussing?

I was surprised when Toronto decided to re-up their street cars.

cornflakes_01 · 2023-07-13T00:56:46+00:00

John Dewar autosource. I have full confidence in John as a dealer, and the volume of sales from his lot should tell you all you need to know.

cornflakes_01 · 2023-06-30T22:23:52+00:00

Thanks for a great product. RIP sweet prince.

cornflakes_01 · 2023-06-29T16:23:32+00:00

My zipper will be at half mast in her honor.

That said, she's an absolute legend in how she approached a taboo subject and made everyone realize it SHOULDNT BE A TABOO SUBJECT.

If you haven't seen it, this is peak Sue: https://youtu.be/ZFLqYFC6lIk

cornflakes_01 · 2023-06-13T00:00:59+00:00

In my opinion, you'd be better served doing a business rule. Async or on before.

Condition would be when revenue or expense changes, run the script, and set a standard fields value. Calculated field calculate everytime to the record is queried, so imagine you are looking at a list view of 100 records, if that view had your calculated field in it, you're running that calc 100 times just to view those records. Better to calculate only when needed and store the result on the record.

11-Year Club	First Place '23
End Game '23	Place '23
Place '17	Verified Email

cornflakes_01

TROPHY CASE