Unique id update

This entity does not have a unique ID? If you try to access the configuration dialog for an entity in your Home Assistant, you might end up seeing this message: This means that this entity does not have a unique identification, e.g., a serial number or another identifier that is guaranteed to be static and never changes. As a result, the normal editing process that allows you to change various settings through the user interface (such as the entity ID, icon, friendly name, etc.) is not possible here. Typically, you’ll see this when you create entities manually using YAML, but it can also appear if the integration that provides this entity, cannot determine a unique ID. This however is not an error, but just a limitation of the integration you use. A few selected integrations (such as template and mqtt) allow the user to define a unique ID. Unique ID: • Only internally in Home Assistant. Entity ID: • Entity with a unique ID: Entity ID only used as a reference, e.g., in automations or dashboards. • Entity without a unique ID: Entity ID acts as the replacement for the non-existing unique ID plus as a reference, e.g., in automations or dashboards. Unique ID: • No. It is a static identifier. Entity ID: • Entity with a unique ID: Entity ID can be adjusted freely (as long as it follows the format . and does not result in duplicates in your Home Assistant). Keep in mind that if you change the entity ID, you also need to update the references, e.g., in automations and dashboards. •...

I am trying to populate any rows missing a value in their InterfaceID (INT) column with a unique value per row. I'm trying to do this query: UPDATE prices SET interfaceID = (SELECT ISNULL(MAX(interfaceID),0) + 1 FROM prices) WHERE interfaceID IS null I was hoping the the (SELECT ISNULL(MAX(interfaceID),0) + 1 FROM prices) would be evaluated for every row, but its only done once and so all my affected rows are getting the same value instead of different values. Can this be done in a single query? simple query would be, just set a variable to some number you want. then update the column you need by incrementing 1 from that number. for all the rows it'll update each row id by incrementing 1 SET @a = 50000835 ; UPDATE `civicrm_contact` SET external_identifier = @a:=@a+1 WHERE external_identifier IS NULL; Assuming that you have a primary key for this table (you should have), as well as using a CTE or a WITH, it is also possible to use an update with a self-join to the same table: UPDATE a SET a.interfaceId = b.sequence FROM prices a INNER JOIN ( SELECT ROW_NUMBER() OVER ( ORDER BY b.priceId ) + ( SELECT MAX( interfaceId ) + 1 FROM prices ) AS sequence, b.priceId FROM prices b WHERE b.interfaceId IS NULL ) b ON b.priceId = a.priceId I have assumed that the primary key is price-id. The derived table, alias b, is used to generated the sequence via the ROW_NUMBER() function together with the primary key column(s). For each row where the column interface-id is NULL, this will genera...

In this article This article for IT professionals describes the function, location, and effect of each Group Policy setting that is used to manage BitLocker Drive Encryption. Group Policy administrative templates or local computer policy settings can be used to control what BitLocker drive encryption tasks and configurations can be performed by users, for example through the BitLocker Drive Encryption control panel. Which of these policies are configured and how they're configured depends on how BitLocker is implemented and what level of interaction is desired for end users. Note A separate set of Group Policy settings supports the use of the Trusted Platform Module (TPM). For details about those settings, see BitLocker Group Policy settings can be accessed using the Local Group Policy Editor and the Group Policy Management Console (GPMC) under Computer Configuration> Administrative Templates> Windows Components> BitLocker Drive Encryption. Most of the BitLocker Group Policy settings are applied when BitLocker is initially turned on for a drive. If a computer isn't compliant with existing Group Policy settings, BitLocker may not be turned on, or BitLocker configuration may be modified until the computer is in a compliant state. When a drive becomes out of compliance with Group Policy settings, only changes to the BitLocker configuration that will bring it into compliance are allowed. This scenario could occur, for example, if a previously encrypted drive was brought out of...

I'm programming a script using PHP and MySQL and I want to get a unique id (consisting of a string: capitals and small letters with numbers) like: gHYtUUi5b. I found many functions in PHP that can generate such numbers but I'm afraid about how to ensure the id is unique! UPDATE: uuid is long, I mean such id like: (P5Dc) an 11 alphanumeric char. You may like the way that we do it. I wanted a reversible unique code that looked "random" -a fairly common problem. • We take an input number such as 1,942. • Left pad it into a string: "0000001942" • Put the last two digits onto the front: "4200000019" • Convert that into a number: 4,200,000,019 We now have a number that varies wildly between calls and is guaranteed to be less than 10,000,000,000. Not a bad start. • Convert that number to a Base 34 string: "2oevc0b" • Replace any zeros with 'y' and any ones with 'z': "2oevcyb" • Upshift: "2OEVCYB" The reason for choosing base 34 is so that we don't worry about 0/O and 1/l collisions. Now you have a short random-looking key that you can use to look up a LONG database identifier. A programmatic way can be to: • add a UNIQUE INDEX to the field • generate a random string in PHP • loop in PHP ( while( ! DO_THE_INSERT ) ) • generate another string Note: • This can be dirty, but has the advantage to be DBMS-agnostic • Even if you choose to use a DBMS specific unique ID generator function (UUID, etc) it is a best practice to assure the field HAS to be UNIQUE, using the index • the loop is...