Tag: joined

How to change color of the points and remove the joined line in the given code?

I use this code

{data1, data2} = Transpose[Table[{2 n, 3 n + 100}, {n, 20}]]; a = ListPlot[{data1, data2}, Joined -> True,    PlotStyle -> {Directive[Red, Thickness[Scaled[10^-2]]],      Directive[Blue, Thickness[Scaled[10^-2]]]}, Mesh -> All,    MeshStyle -> Directive[PointSize[Large], Red],   ClippingStyle -> False]

and I get this picture

enter image description here

Now, I have two questions:

  1. How can I ask Mathematica to change the color (red to blue) and shape (circle to diamond) of the plotmarker in the upper curve?
  2. How can I remove the joined line for the upper curve?

Match two distinct values from a single column in a joined table

I have three tables:

class: class_id class_name  student: student_id student_name  class_schedule: class_id student_id

I want to select all the classes where studentA and studentB are in the same class using the student names. I can use a subquery to pull all the classes studentA is in, and then from that subset the classes that studentB is in and that works. That being said, it is terribly inefficient. I have tried a number of solutions including joining the same table twice, once for each value I want to find, but always get an empty result set.

For testing and prototyping purposes I am using sqlite, but will reside on DB2 long term.

How to issue a windows machine cert for a non-domain joined computer?

I have a Windows Server 2012 AD/CA and domain joined computers automatically receive the CA public cert and also get a computer certificate generated and pushed using GPO auto-enrollment. All of this is used for 802.1X and works fine.

Now I need to generate a certificate for a non-domain joined win10 computer, so that it can also authenticate via 802.1X.

This is proving quite difficult. I’ve come across this post that describes two ways to accomplish this:

option 1

Export the certificate from a domain joined computer. I’ve tested and this works, but as explained in that post the drawback is that all the non-domain joined computers will share the same certificate.

option 2 (preferred)

  1. Create an account in AD
  2. Issue a certificate from a template that allows the private key to be exported
  3. Using name mappings, attach the certificate to the account
  4. Create an SPN that matches the SAN on the certificate..i.e. if the SAN is computer.domain.com, you need to create a SPN on the account host/computer.domain.com
  5. Install certificate on to target workstation/device

This follow-up comment seems to suggest that the five steps above can be reduced to the following:

  1. Create computer AD account
  2. Issue a computer certificate for the non-domain computer adding SAN:UPN=<hostname>$ @<domain.tld>
  3. Install computer certificate on client

You can make the hard option a little easier and reduce a couple of the steps by using a SAN entry in the certificate with a format of SAN:UPN=<hostname>$ @<domain.tld>. This results in a certificate that has an NT Principle Name of <hostname>$ @<domain.tld> in the SAN field which is then appropriate for authentication to the NPS as a pure computer object. The only dependency is then the creation of a computer account in Active Directory and adding it to the respective groups for AuthZ.

I’ve created a Computer AD account with the hostname win10test but I don’t understand how to generate the certificate and how to add the SAN:UPN=<hostname>$ @<domain.tld> to the certificate.

Do I need to create a CSR on the non-domain computer?

Can someone please elaborate on the instructions from the MS forum post. Thank you.

This operation can be performed only on a computer that is joined to a server farm by users who have permissions in SQL Server

This operation can be performed only on a computer that is joined to a server farm by users who have permissions in SQL Server to read from the configuration database.

I get this error while accessing central admin after server reboot in production.

Checked SQL services – running; checked permission for farm account in databases – sys admin in sql server; password for farm account is never expiring; no default gateway change in web server; firewall disabled

Is a domain joined windows machine’s objectGUID or ObjectSID as stored by Active Directory also stored locally?

Working on an inventory project where I need to link a computer to an object in Active Directory.

I have an export of all computer objects from Active Directory including some unique identifiers such as objectGUID and objectSID.

I now need to query the local device (ideally via powershell) for one of those unique identifiers so I can positively link the device to the computer object in Active Directory. The device may be off network, and not able to access a domain controller when it is queried.

Is the Active Directory computer object’s objectGUID or objectSID attribute stored locally on a domain joined computer?

What happens to Azure AD joined devices if you turn off user registration after they are joined?

We discovered that the ‘Users may join devices to Azure AD’ setting in our Azure AD was set to ‘All’ by default. At this point we have a number of users personal devices joined. Before switching it to ‘None’ I’m trying to get a feel for what, if any, impact changing it will have on the already enrolled devices.

Force ‘fetch joined’ relations to include IDENTITY of their ManyToOne relations using HYDRATE_ARRAY?

I have a query in which I’m joining a number of tables to my original Person entity. A Person may have multiple Child relations (OneToMany), and a Child may have a School they go to (ManyToOne). Problem is, I don’t need the entire School entity that connects to each child, only their id, which is already stored on Child.

I’m using a Paginator to iterate through the results and I use HYDRATE_ARRAY to reduce overhead of the ORM parsing data to entity objects. But the id fields of unfetched relations are not returned this way, and thus, the School id isn’t either.

I may join the School entity too, but since the identity is already stored on the Child records, I don’t see why I should further reduce performance by having the database join another table. Fetching results as entity objects would also solve the problem, but also at the cost of performance. How can I get the id to apper the results without having to unnecessarily join the the School entity or having to hydrate the results as objects?

$  query = $  em->getRepository(Entity\Person::class)->createQueryBuilder('p');  $  query   ->select([     'p as person',     'w.name as workplace_name',     'c',   ])   ->leftJoin('p.children', 'c') //Entity\Child   ->leftJoin('p.workplace', 'w') //Entity\Company   //...  ; $  paginator = new Paginator($  query); $  paginator->getQuery()   ->setHydrationMode(\Doctrine\ORM\Query::HYDRATE_ARRAY);

Choice of index on date rage column having selectivity around 20 % and joined with other table

select  c.customer_name , c.customer_address, i.invoice_num, i.invoice_date,i.invoice_amount from Customer c,   ---100 k rows Invoice  i   ---- 10 M rows     where c.cust_id=i.cust_id AND c.customer_name=' Tarun Kumar'  -- exactly one row AND i.invoice_date >= (sysdate-12)    -- 20 % of all rows

Customer Table

 customer_name,cust_id  --- Composite index

Invoice Table

 cust_id

Should I add the index on invoice_date ? Composite index (invoice_date, cust_id )