Is there a rule table/matrix that has rules in the rows and all the devices used in the rows?
2 Likes
Doesn’t exist at the moment, but on the surface wouldn’t be a hard app to create assuming the rules expose the devices used on the status page like a normal app.
3 Likes
Took less than that once I got back home and in front of the keyboard 
This should be close but you'll need to be on at least HE v2.4.0.x (currently in beta): https://raw.githubusercontent.com/thebearmay/hubitat/refs/heads/main/apps/ruleDevList.groovy
2 Likes
Themaybear,
Thanks for putting this together. Unfortunately I’m not an expert in the Hubitat world, so I’m not sure what to do with this code. If you could let me know how to run this that would be great.
Go to the App Code tab under the Developer’s Area, and select add new app. Then select import, copy/paste the URL above, click Yes to the prompt about overwriting the editor, and then click save. After that go the Apps tab and select Add User App - you should see the app we just created. Click it to install; it is set to run on install so you should either get a list of all your rules with their devices, or, if you aren’t in the Beta group, a message that you need to wait for 2.4.0.x to be released.
Thebearmay,
THANKS!!!
This worked out great after I downloaded 2.4.0. I managed to use the file to create an excel spreadsheet (with IF and Find functions) that I've itching to do for a long time. The ultimate goal was a visual spreadsheet showing the rules in the first column, the devices in the top row and their usage designated by an "X". This allowed me to see the rules that are missing needed devices, (no X and highlighted in red),
Glad it worked for you. I thought about the layout you created with Excel and decided I’d wait to see if it was really needed as it ends up to be a very large table if you have a normal amount of devices and rules.
1 Like
Amy chance you could check the device lists for and delete repeated devices?
Shouldn’t be too hard to do, might be a couple of days before I get time to look at though.
1 Like
Yeah, I saw the repeaters as well, but dumping the fileinto Excel and using the visual spreadsheet negated that issue. However, I did notice that it would also be helpful to include any triggers, (HSM, time, mode…) and conditions that were included in the rules
